Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jan 14, 2023 04:50 AM
I can not get this formula to work.... is it completely wrong or am I missing parathesis?
Jan 14, 2023 05:31 AM
I count 7 IFs, so you should have 7 closed parentheses at the end, not 4. Also, sometimes Airtable can get snippy about not have a closing ‘value if false’ at the end of a bunch of nested IFs. If adding the extra parentheses doesn’t work, you may need to add that at the end.
Having said that, this is a great candidate for a SWITCH instead of multiple nested IFs.
Jan 14, 2023 06:08 AM
SWITCH worked perfect - thank you!
Jan 14, 2023 03:20 PM
Yay!