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
Ömer
Answers
-
Hello @Oemer Faruk Aslantas ,
You may wish to review the different Time Formulas created by another Smartsheet Member here: https://community.smartsheet.com/discussion/68947/formulas-for-calculating-time/p1
Hyperlinked are Sheet examples of how these are used, and are broken down to understand what each function does.
Let me know if you have any questions!
Regards
Sean
-
Hi Sean,
thx for your response. I already have seen all the files from the link. What I am trying is to run a workflow when a specific date is reached. e.g.
- A new entry has timestamp: 02/02/2021 8:23 PM
- --> I want to run the workflow 4 hours later, so all I want is to compare between the created time and the current time.
So far I had no success with all my attempts..
Kind regards
Ömer
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!