Time Since New

daveyboy

Hi Guys

I have a column that shows when a ticket was created in Smartsheet. Now we just want a column that shows many hours have passed since the ticket was created. 

What formula do you use to show the number of hours passed since created?

We have a Zapier zap hitting the sheet to wake it up every hour

Thanks!

eric.o

Hello,

 

Currently, we don’t have a method to calculate time but this will be considered as a possibility for future development.

 

You may be able to utilize a Modified Date to see the difference in time when the row is altered but there currently isn't a method to subtract these values from each other. This Help Center article outlines how to utilize Modified Date: https://help.smartsheet.com/articles/1964567-system-columns

 

Cheers, 

Eric  

Smartsheet Support