Formula combining IF and AND


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.

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

1 Like

Great, it works now, thank you so much!

1 Like

Glad I could help! :slight_smile: 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. :slight_smile:

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.