Help

Re: Formula combining IF and AND

Solved
Jump to Solution
847 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Evi_Beckers
5 - Automation Enthusiast
5 - Automation Enthusiast

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
ScottWorld
18 - Pluto
18 - Pluto

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
ScottWorld
18 - Pluto
18 - Pluto

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: