Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

IF 3 columns that match then

Topic Labels: Formulas
Solved
Jump to Solution
215 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

1 Solution

Accepted Solutions

IF(
AND(
R > 1,
F > 2,
M > 2

                   ),
     "Loyal Customer"
      )

I figured it out

See Solution in Thread

1 Reply 1

IF(
AND(
R > 1,
F > 2,
M > 2

                   ),
     "Loyal Customer"
      )

I figured it out