I’m in a bit of a bind trying to put together a formula for what I’m trying to do here.
I have 3 different single select fields, which based on if they meet certain criteria, will populate another formula field that’ll show “Complete” or “Incomplete”. That formula is working wonderfully. However, I’m trying to come up with a formula that’ll state the reason as to Why it’s showing as incomplete.
I can sort of get it to work for one field, but not multiple.
Here is the formula I have for the field that populates with “Complete” or “Incomplete”:
I played around with the IF(OR() sections and came up with something quite similar, but couldn’t figure out exactly where I went wrong. I’ll be referring back to your examples for learning references. Thank you very much for your help, Jeremy! This isn’t the first time. I’ll get the hang of formulas for Airtable eventually.