Within 30 Days From Today

A Rose
✭✭✭
Hi,
I have 2 columns,
- Todays Date, Formula: =Today
- Date Submitted,
I need a formula to tell me if Date Submitted is more than 30 days ago, if yes say "Overdue"
Any ideas?
Thank you!😀
Answers
-
Hi @A Rose ,
Try this:
=if([date submitted]@row <TODAY(-30), "Overdue","")
Let me know if it works for you!
Best,
Heather
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!