Can you calculate difference in hours? between NOW and given Datetime?

Hello everyone,

i was trying to find to find a way to trigger workflows 2hours later then they should but couldn't find any solution myself.

Assume this is my Created date. Is there a way to calculate the difference between the Created(date) and NOW in Hours? My idea is following:

IF (Created (date) - TimeNOEW) 4 --> start Workflow. So when this number changes to 4, the workflow starts.

Haven't found any function for this. Only found DATEONLY() and TODAY(). But DATEONLY() extracts the Date, not the time.

Thanks in advance for your advice.

Kind regards



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!