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
#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.
User | Count |
---|---|
42 | |
25 | |
24 | |
19 | |
15 |