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")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!