Help

And statement and two separate fields

Topic Labels: Formulas
480 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Heidi_Wussow
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello,

I’m new to airtable and struggling to write a formula to ask the system to look at two separate fields and apply a label if the conditions are met.

I have this formula already

IF(IS_BEFORE({Materials Received Date (hide)},“12/16/21”),“Early Deadline”)

and I’d like to add that the system also look at another field, application submitted, before 12/18/21 and also apply the label Early Deadline.

Both statements should be true in order for the label to be applied. I was thinking I could just copy my original formula that worked and join them with an AND but I get an error.

Thanks in advance!!

1 Reply 1

Here you go:

IF(
AND(
IS_BEFORE({Materials Received Date (hide)},"12/16/21"),
IS_BEFORE({Application Submitted Date},"12/18/21")
),
"Early Deadline")