Adding in "Overdue" in formula using one date value vs. Today

Options

I am trying to create a formula to flag something is overdue, when comparing it to Today's Date Only. What is the formula? I have been trying this one:


=IF(AND(TODAY() > [Tactical Due for Approval]@row, "OVERDUE"))


But it will not work

Answers

  • VicFar
    VicFar ✭✭
    Options

    So i was able to get it to work using =IF([Tactical Due for Approval]@row < TODAY(), "Overdue"), but i think i need it to be more complex. How can i transform it to take into account "Tacticals Approved". I would need to add in a rule, if it is approved than the tactical overdue would be "Complete" if it is "Not Approved" it would be "Overdue"


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!