Using Symbols to mark Past Due

McAfee Electric Mgr

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

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

@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?