Hi all 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 l…

Contains() is only matching first option on list

Paul_Danyliuk May 25, 2019, 4:58pm 8

Happy to help

P.S. Here’s the solution with a combined table of all services. Look at how much simpler all formulas get, while all behavior stays the same

3 Likes

Select list - selecting from a filter

Topic		Replies	Views
Display Filter - "Contains" a list option	1	553	September 12, 2018
Why is Contains() working only for the first entry of a list?	11	724	February 14, 2023
Getting Contains() to work with Multiselect Columns	5	1199	May 20, 2020
FILTER formula output rows with .Contains	3	800	October 27, 2020
Selecting more than one option in Multiselect List empties data from formulas using the selection	4	1761	May 20, 2020