Time Since New

Options
daveyboy
daveyboy ✭
edited 12/09/19 in Formulas and Functions

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!

Tags:
· Share on FacebookShare on Twitter

Comments

  • eric.o
    eric.o Employee
    Options

    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

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!