I need help with a formula. I want to mark overdue projects.

Cristina W
✭✭✭
This is a sample of the projects I have, and this is the formula I am using, but it does not seem to be working: =IF([End Date]@row > TODAY() +30), "Overdue"
Best Answer
-
@Cristina W Try =IF([End Date]@row < TODAY(30), "Overdue")
With the formula, you are capturing anything over 30 days past due or within 30 days??
If it is within the next 30 days, the formula works as above. If past 30 days, change the number to -30
Answers
-
@Cristina W Try =IF([End Date]@row < TODAY(30), "Overdue")
With the formula, you are capturing anything over 30 days past due or within 30 days??
If it is within the next 30 days, the formula works as above. If past 30 days, change the number to -30
-
Thank you @Eric Law
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!