I’m trying merge two lists into a single ENUMLIST so the use can check off various items. So the simplified formula for the suggested value is:
ANY(Select(Table[ENUMLIST],[Something]=TRUE))
+
Select(Table[TEXT],[SomethingElse]=TRUE)
Lets say that ENUMLIST=“a,b,c” and the select function pulls in “1”, “2” and “3”. What I’m seeing is:
a,b,c
1
2
3
whereas I want to see:
a
b
c
1
2
3
I’ve tried wrapping either, both and all in a LIST() equation. If anything that makes them group more.
Anyone have any idea what I’m doing wrong?
Solved! Go to Solution.
Try:
SPLIT(Select(Table[ENUMLIST],[Something]=TRUE), " , ")
+
Select(Table[TEXT],[SomethingElse]=TRUE)
User | Count |
---|---|
39 | |
35 | |
29 | |
23 | |
18 |