Time and Date calculation
Is there a way to show how many hours passed from the time the form was submitted/created to the running/current time and date?
I am trying to show the running hours lapsed while the entry submitted is still in the "Pending Status"
I have the following column available
I wanted to show the current duration in hours that the entry is still pending comparing it to the current time and date so that if someone is looking on the report/file, it will let them know how long it has been since the entry is in "Pending" status.
Can someone give any suggestion? Thanks
Answers
-
Using Smartsheet new AI feature =IF([last status]@row = "pending", (TODAY() - [Countdown]@row) * 24, 0)
Have a great day.. 😀
Cheers.
-
There is no current time that is available to use in calculations, so there is no elapsed time function. There is a way to work around it though.
Okay, there are a couple of steps to get this to work.
- Create a [Check Box] column that only accepts checkboxes
- Create a [Modified Date] column
- Create an automation to click/unclick the [Check Box] every hour.
- Calculate the difference between the your [Timestamp] column and the [Modified Date] column
I have included a picture of the automation layout. You need to make sure that the automation can tick/untick the box so that something updates on the row.
The Modified Date is the endtime that you need to use in the calculation.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!