Calculation of Date Values

1 - How can I add hours (5 or 13 or even 38 hrs) from a dropdown to current time and it shows expected close datetime - I am thinking of the function NOW() + hrs from a dropdown, but it doesnโ€™t work

2 - How can I calculate the difference between dates? - Same function as DatedIf in googlesheet

0 1 746
1 REPLY 1

#1 - Add an Enum field with options like 1, 2, 3, etc. what ever numbers you want to choose and then set the option โ€œBase typeโ€ as a number. Then you can calculate your DateTime value like NOW() + [EnumField]
#2 - HOUR(TODAY()-[Date])/24 will do that.

Top Labels in this Space