Multiple choice field as a parameter in the IF formula

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

Welcome to the community, @Edward_Zev!

Try this instead:

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

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

1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.