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! 😍


You are my hero :smiling_face_with_sunglasses:


Reply