Time and Date calculation

Marie Gladys Rosales

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

Jason P

Hi @Marie Gladys Rosales

Using Smartsheet new AI feature =IF([last status]@row = "pending", (TODAY() - [Countdown]@row) * 24, 0)

Have a great day.. 😀

smartsheetUser1345

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.

1. Create a [Check Box] column that only accepts checkboxes
2. Create a [Modified Date] column
3. Create an automation to click/unclick the [Check Box] every hour.
4. 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.