Hey All I am stumped and have not been able to find a solution. Any help would be much appreciated. Problem: I have 3 columns that match “Champion” I have a 4th column I want to print “Champion” but only if all three columns match Champion I have tried SWITCH({R segement} & {F segement} & {M segement copy}, “Champion”, “Champion”) but is not working Thanks

IF 3 columns that match then | Airtable Community

Hey All

I am stumped and have not been able to find a solution. Any help would be much appreciated.

Problem:

I have a 4th column I want to print “Champion” but only if all three columns match Champion

I have tried

SWITCH({R segement} & {F segement} & {M segement copy}, “Champion”, “Champion”)

but is not working

Thanks

Page 1 / 1

IF(

AND(

R > 1,

F > 2,

M > 2

                   ),

     "Loyal Customer"

      )

I figured it out