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

Multiple choice field as a parameter in the IF formula

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

Hi everyone

So I have this simple IF formula
IF({Method}=“Digital”,1,0)
Where {Method} is a multiple choice field, and can contain different type beside “Digital”.
My problem is that this formula returns 1, only when {Method} is strictly equal “Digital” and nothing else.
And I want it to return 1 if one of values is “Digital”.
For example: Digital, Offset, Heatpress

1 Solution

Accepted Solutions

Welcome to the community, @Edward_Zev!

Try this instead:

IF(
FIND("Digital",{Method}),
1,0)

See Solution in Thread

2 Replies 2

Welcome to the community, @Edward_Zev!

Try this instead:

IF(
FIND("Digital",{Method}),
1,0)

Awesome! :heart_eyes:
You are my hero :smiling_face_with_sunglasses: