Skip to main content

Dear Airtable Community,


I am trying to edit a formula with IF to make it capture the conditions of two or more fields. I have two fields that are either empty or not empty.


This is the formula I am using for one field and it works just fine:

IF({Constancia}, TRUE(), FALSE())

How can I edit this formula to have it work for two or more fields?


I am new to Airtable so please spell it out for me. (sorry)


I thank you in advance of your help with this question.


Rob

Rob, it should depend on what you want the new formula field to do.


As far as I understand, that formula reads “If there is data in {Constancia}, return ‘1’ and if there is no data, return ‘0’”


But you have another field - {Other} let’s say.


For {Other} will it also be a data or no data question?

What do you want the formula to do if there is data in both {Constancia} and {Other}? Or neither?

Hi Eli_Kent, Thanks. {Constancia} is one field and it will be either empty or not empty. The other field is {Report Card} and it is either empty or not empty.


I want a formula that will return 1 if both fields are not empty and return 0 if either field is empty.


does that make sense? Thank you for your help.


Rob

I apologize. My question needs clarification.


I have a table with multiple fields. Two fields are for documents: “Recommendation Letter” and “Report Card” I would like to add a field with a formula that will show me that both fields are not empty.


{Rec Letter} is one field and it will be either empty or not empty. The other field {Report Card} and it is either empty or not empty.


I need a formula that will return 1 if both fields are not empty and return 0 if either field is empty.


Thank you for your help.


Rob


I apologize. My question needs clarification.


I have a table with multiple fields. Two fields are for documents: “Recommendation Letter” and “Report Card” I would like to add a field with a formula that will show me that both fields are not empty.


{Rec Letter} is one field and it will be either empty or not empty. The other field {Report Card} and it is either empty or not empty.


I need a formula that will return 1 if both fields are not empty and return 0 if either field is empty.


Thank you for your help.


Rob



Use the AND() function to combine more than one condition:


IF(AND(Constancia, {Report Card}), TRUE(), FALSE())

You can pack as many conditions into AND() as you want. Same thing with its counterpart, OR(). For more on these, check out this video:


Use the AND() function to combine more than one condition:


IF(AND(Constancia, {Report Card}), TRUE(), FALSE())

You can pack as many conditions into AND() as you want. Same thing with its counterpart, OR(). For more on these, check out this video:




Thank you Justin_Barrett. This answers my questions perfectly!!!


And away I go!


Rob

Reply


Terms & Conditions