I’m using the the following formula:
if(AND(Contains(thisRow.Service, "Manufacture"), Contains(thisRow.[Job Type], Laminates.[Job Type].split(","))), "Yes", "no")
thisrow.[job type] is a selection box with the choices: Vehicle Graphic, Window Graphic and Banner
Laminates.[Job Type] is a list of those same three choices: Vehicle Graphic, Window Graphic, Banner
Using the above formula, If I select Vehicle Graphic it give me the result “Yes” which is correct as its a match. If I change the selection to “Window Graphic” or “Banner” is gives me the result “No” which is WRONG. It should still be a match.
Whats wrong with my formula?