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:
Lets say that ENUMLIST=“a,b,c” and the select function pulls in “1”, “2” and “3”. What I’m seeing is:
whereas I want to see:
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?