Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Oct 04, 2019 02:41 PM
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.
Oct 04, 2019 03:49 PM
As described, you only need one IF() statement but you will need the AND() operator. The formula would be:
IF(AND(TODAY()>{Anticipated Due Date}, {Status}!='Completed', {Status}!='Not Applicable'),'Overdue','Not Overdue')
Assuming you have a Pro account, yes you can set up field coloring to highlight rows where the above formula results in ‘Overdue’.