Merge an ENUMLIST & Select() into another ENUMLIST

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 Solved
2 14 683
1 ACCEPTED SOLUTION

Steve
Platinum 4
Platinum 4

Try:

SPLIT(Select(Table[ENUMLIST],[Something]=TRUE), " , ")
+
Select(Table[TEXT],[SomethingElse]=TRUE)

View solution in original post

14 REPLIES 14
Top Labels in this Space