Skip to main content

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)

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: