IF Function Combined

[christianfcbmx]

Dear Community I have a question:

I want to use an "If" function but also need to filter by an specific status from another column ("Green", "Yellow" , "Red"), in this case "Red"... (all in the same formula)

Im doing this but I dont know how to continue:

Column 1 = IF('EXTR-INC&WO-(Chil'[Sta]="Asigned",1 ,IF('EXTR-INC&WO-(Chil'[Sta]="In Progress",1 ,IF('EXTR-INC&WO-... (Im Converting into "1" those status as you see as long as the other column that I have named "condition" said "Red" ..it is too complicated?

Any advice will be so much appreciated!

[Zubair_Muhammad]

HI @christianfcbmx

If the search is with a single Column you can shorten the CODE by using the "IN" operator

=
IF (
    'EXTR-INC&WO-(Chil'[Sta] IN { "Asigned", "In Progress" }
        || 'EXTR-INC&WO-(Chil'[Column] IN { "__", "__" },
    1,
    ___
)