Help

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

Need Assistance on Nested IF Formula

Topic Labels: Formulas
428 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

1 Reply 1

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’.