Calculation of Date Values

AppSheet AppSheet Q&A
1

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

2

#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.

1 Like