Skip to main content

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.

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

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!

Great, it works now, thank you so much!


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

Reply


Terms & Conditions