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

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?

‘Tagged ‘,’’)

Thank you so much in advance.

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.


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