Help

Can't get a simple IF() and AND() formula to work

Topic Labels: Formulas
677 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Markus_Wernig
8 - Airtable Astronomer
8 - Airtable Astronomer

I thought this was simple, but for some reason, it’s not working, no matter what I try.

I am trying to set up a formula field that looks at three specific fields in my table and if these three fields are populated and not empty, the formula field should fill in the word “Tagged”.
If one or more of the three fields are empty, the formula field should stay empty as well.

What am I doing wrong here?

IF(
AND(
{WRITER(S)} !=BLANK(),
{PUBLISHERS} !=BLANK(),
{GENRE + SUB GENRE} !=BLANK()
),
‘Tagged ‘,’’)

Thank you so much in advance.

2 Replies 2
Raminder_Singh
7 - App Architect
7 - App Architect

Try this: IF(AND({WRITER(S)}, {PUBLISHERS}, {GENRE + SUB GENRE}), "Tagged")

Thank you. It all works now. Your solution works.

My problem was that the fields {WRITER(S)} and {PUBLISHERS} were formula fields that combined three other fields. I overlooked a “rogue comma” when I created the formulas for those fields, so they never were empty, even though I thought they were. No wonder my IF formula was always returning true results.

It