so I’m using this formula to built a list in a virtual column
LIST(
IF([Brush]=TRUE,“Brush”,""),
IF([Rake]=TRUE,“Rake”,""),
IF([Matt]=TRUE,“Matt”,"")
)
Whats weird is that the list seem to be including the blank items, i.e. those which are FALSE. For example, if only [Brush]=TRUE then it will show
Brush,
Tried unique() but that still shows one blank item.
Any ideas
Solved! Go to Solution.
Hi Simon,
Does the following expression help
LIST( IF([Brush]=TRUE,“Brush”,""), IF([Rake]=TRUE,“Rake”,""), IF([Matt]=TRUE,“Matt”,"") ) -LIST("")
I’ve done an almost identical list as the suggested items in an ENUMLIST and it doesn’t pull in the blanks
Hi Simon,
Does the following expression help
LIST( IF([Brush]=TRUE,“Brush”,""), IF([Rake]=TRUE,“Rake”,""), IF([Matt]=TRUE,“Matt”,"") ) -LIST("")
Awesome @Suvrutt_Gurjar thats done it
@1minManager @Suvrutt_Gurjar
How about like this?
LIST(
IFS([Brush]=TRUE,“Brush”),
IFS([Rake]=TRUE,“Rake”),
IFS([Matt]=TRUE,“Matt”)
)
Hi @LeventK ,
Thank you. I also thought IFS (… will work. Somehow IFS (… also seems to introduce blanks.
Is it worth listing this as a bug since
LIST(
IFS([Brush]=TRUE,“Brush”),
IFS([Rake]=TRUE,“Rake”),
IFS([Matt]=TRUE,“Matt”)
)
Should work as I described?
Not a bug because IFS() correctly returns a blank value, which is itself a value.
... - LIST("")
is the correct solution.
Is that the same with IF() too?
User | Count |
---|---|
44 | |
29 | |
22 | |
20 | |
14 |