Hi! I’m new to Airtable and getting our bases set up. I’d like to have a field/column to notify us at quick glance if something has passed the “Anticipated Due Date” AND not been marked as “Completed” or “Not Applicable” for the Status. I’m struggling to find the correct formula for this.
Is it also possible to also have this formula set to change color, say to red, when “Overdue” as you could do in excel?
I’m terrible at properly formatting these formulas… sigh.