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

Cristina W
Cristina W ✭✭✭
edited 11/01/23 in Formulas and Functions

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

  • Eric Law
    Eric Law ✭✭✭✭✭✭
    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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!