Using Symbols to mark Past Due

I am trying to Mark the Due for Maintenance Box with the Red Explanation (High Priority) if the due date is before today.

Here is the formula I tried but it's not working:

=IF([Next Maintenance Due]@row < TODAY(), "High")


  • Nick Korna
    Nick Korna ✭✭✭✭✭✭

    Hi @McAfee Electric Mgr,

    What result are you getting?

    Your formula is working fine for me. The only thing I can think of is if your "Next Maintenance Due" column is not set to "Date" as the type, then the check vs. today's date isn't carried out and you get #INVALID OPERATION instead, as you can see below:

    The first row has your formula in it, the second one is comparing to the same date, but as a text field instead of date.

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭

    @McAfee Electric Mgr

    Are you getting an error message, or is the ! just not appearing when it should?

    I'm assuming that the Next Maintenance Due column is indeed a date-type column with a real date-type value?


    Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!