How to calculate time

Hello Everyone,

I hope you are well and safe,

I am working on one project in which I need to check if the time is greater than 24 hrs.

For Example, if the Status is changed to In Progress the created time would be 11/17/22 4:08 PM now I want to check if it is more than 24 hrs means 11/18/22 4:08 PM and still, the status is In Progress then it shows me some red flag but I am unable to find any formula for it and as per my knowledge there is no way to check with the exact time.

Any help would be appreciated.


Kaveri Vipat

Senior Associate - Smartsheet Development, Ignatiuz Software

2023 Core Product Certified

Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️"


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!