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