This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
So I have the following:
IF(
TODAY() > {Date Due}, “OVERDUE”
)
I have a Column named ‘Days’ for days left to do my task, so I made the following, using the nested IF tutorial:
IF(
TODAY() > {Date Due}, “OVERDUE”,
IF({Days} < 5, “Soon”)
)
I’m tryi...