Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Formula combining IF and AND

Topic Labels: Formulas
Solved
Jump to Solution
259 3
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello,

I’m trying to create a formula to give a certain status to a record when 2 criteria are met.
This is my attempt but I get the status “Onvolledig” in every cell although there are cases where the result should be “Volledig”:

IF(AND({Betaalopdracht} = 1,({Huurders} = ‘’)), “Volledig”, “Onvolledig”)

Field {Betaalopdracht} is a Checkbox.
Field {Huurders} is a linked record
=> so if the checkbox is ticked AND {Huurders} is not empty, then I would like to get the status “Volledig”.

Thanks in advance for the help! And I’m sorry if my explanation should be insufficient, I’m new to Airtable.

1 Solution

Accepted Solutions

Welcome to the community, @Evi_Beckers!

You want Huurders to NOT be empty?

That part of your formula would look like this:

Huurders != ""

(You also don’t need the parenthesis nor the brackets for that part of your formula.)

See Solution in Thread

3 Replies 3

Welcome to the community, @Evi_Beckers!

You want Huurders to NOT be empty?

That part of your formula would look like this:

Huurders != ""

(You also don’t need the parenthesis nor the brackets for that part of your formula.)

Great, it works now, thank you so much!

Glad I could help! :slightly_smiling_face: If you don’t mind, could you please mark my comment above as the solution to your question? This will help other people who have a similar question in the future. :slightly_smiling_face: