Flag a date
Options
Samuel Dowdy Jr.
✭✭✭✭✭
How do I say
=if the date is 30 days in the past = flag
Answers
-
See below. Change column name to match your Date column name.
=IF((TODAY() - [Date]@row) > 30, 1, 0)
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!