Mar 05, 2021 03:57 AM
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.
Mar 05, 2021 04:06 AM
Try this: IF(AND({WRITER(S)}, {PUBLISHERS}, {GENRE + SUB GENRE}), "Tagged")
Mar 05, 2021 10:13 AM
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