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
Dec 16, 2021 07:26 AM
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!!
Dec 16, 2021 07:30 AM
Here you go:
IF(
AND(
IS_BEFORE({Materials Received Date (hide)},"12/16/21"),
IS_BEFORE({Application Submitted Date},"12/18/21")
),
"Early Deadline")