The use case is that I have a form where a user will choose red, blue, or green in the “COLOR SELECTION FIELD”.
I have a field (as shown below) that will return all columns from another table when that selection above is found in the “COLORS” column for that other table.
FILTER(“TABLE”, ([COLOR SELECTION] = [COLORS] ))
What I want is FILTER ROWS WHERE COLOR SELECTION IS CONTAINED WITHIN COLORS and also to choose the columns if possible.
The COLORS field is not an exact match to COLOR SELECTION…more like tags where it can have yellow, green, blue (comma separated). I want all COLORS column values where COLOR SELECTION = “Blue” for example, whether exact match or if “Blue” is simply found in the COLORS value ( yellow, green, blue for example).
LinkedIn
Twitter
