Help

Multiple choice field as a parameter in the IF formula

Topic Labels: Formulas
Solved
Jump to Solution
951 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Edward_Zev
5 - Automation Enthusiast
5 - Automation Enthusiast

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
ScottWorld
18 - Pluto
18 - Pluto

Welcome to the community, @Edward_Zev!

Try this instead:

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

See Solution in Thread

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

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: