Hello fellow Airtablers!
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”:
IF(AND(Status = "Done", {Billing Status} = "Payment Received", {E-file Status} = "Accepted", {Billed}!=BLANK()), "
Complete", "
Incomplete")
Here’s an image of what it looks like:
As you can see, it’s marked as Incomplete, because the billing status is not marked as “Payment Received”.
I’m attempting to create a column after the {Final Status} column that will show why it’s marked “Incomplete”. Is this possible?
Any help or suggestions are greatly appreciated. I’m still a bit new to Airtable and am trying to learn as much as I can.
Thanks in advance!