Formula combining IF and AND

[Evi_Beckers]

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.

[ScottWorld · Accepted solution]

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.)

[Evi_Beckers]

Great, it works now, thank you so much!

[ScottWorld]

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: