Formula for last 24 hours

Tana Rucker
Tana Rucker Overachievers Alumni
edited 12/09/19 in Formulas and Functions

Hello my friends - I need to create a formula to find any new rows added to a sheet in the last 24 hours.  My created on system column is added.  We currently are using the TODAY function, however, that only captures those added today, which leaves out a great deal of data when generating a report in the early a.m. hours.  If no hour formula, I suppose I can leverage TODAY-1?

Tana Rucker

Charter Communications



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!