I’m a new Airtable user and still learning the ropes. I have a nested if statement that keeps getting kicked back as invalid and I cannot figure out what the problem is:
Here’s what I need the formula to populate:
IF{Appra Waived?} = ‘YES - Waived’, “N/A”,
IF{Appra Waived?} = ‘NO - Needed’, then:
a)IF{Appra Accepted By Due Date} = ‘NO’, then insert a date 4 days after {Appra Order Complete} not including weekends and holidays.
b)IF{Appra Accepted By Due Date} = ‘YES’, then insert a date 2 days after {Appra Order Complete} not including weekends and holidays.
Here’s the formula I wrote that does not work:
IF({Appra Waived} = ‘YES - Waived’, “N/A”,IF({Appra Waived} = ‘NO - Needed’,IF({Appra Accepted By Due Date} = ‘NO’, DATETIME_FORMAT(WORKDAY({APPRA ORDER COMPLETE},4,2020-10-12,2020-11-11,2020-11-26,2020-12-25,2021-01-01,2021-01-18,2021-05-31,2021-07-05,2021-09-06,2021-11-11,2021-11-25,2021-12-24,2021-12-31’),IF({Appra Accepted By Due Date} = ‘YES’, DATETIME_FORMAT(WORKDAY({APPRA ORDER COMPLETE},2,2020-10-12,2020-11-11,2020-11-26,2020-12-25,2021-01-01,2021-01-18,2021-05-31,2021-07-05,2021-09-06,2021-11-11,2021-11-25,2021-12-24,2021-12-31’), ‘DD-MM-YYYY’))))))
I’m sure that the problem is painfully apparent to some of you, but go easy on me :slightly_smiling_face:
Please help me figure out what’s wrong with this formula.
