hello -
I am trying to write a formula given the following: if column [A] contains 'bottle' and column [B] contains 'blister' then 1 else 0.
Hi @jenki07
Try like this:
if CONTAINS([ColumnA], 'bottle') and CONTAINS([columnB], 'blister') then 1 else 0 endif
Hey @jenki07, the syntax here just needs cleaning up a little and you'll also need to add 'endif' to close out the statement:
if Contains([A], 'bottle') and Contains([B],'blister') then 1 else 0 endif
Try this in the formula tool
IF [A] = "bottle" AND [B] = "blister" THEN 1 ELSE 0 ENDIF
Should hopefully work.