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.