List showing blank items

[1minManager]

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

[1minManager]

I’ve done an almost identical list as the suggested items in an ENUMLIST and it doesn’t pull in the blanks

[Suvrutt_Gurjar · Accepted solution]

Hi Simon,

Does the following expression help

LIST( IF([Brush]=TRUE,“Brush”,""), IF([Rake]=TRUE,“Rake”,""), IF([Matt]=TRUE,“Matt”,"") ) -LIST("")

[1minManager]

Awesome @Suvrutt_Gurjar thats done it

[LeventK]

@1minManager @Suvrutt_Gurjar
How about like this?

LIST(
	IFS([Brush]=TRUE,“Brush”),
	IFS([Rake]=TRUE,“Rake”),
	IFS([Matt]=TRUE,“Matt”)
) 

[Suvrutt_Gurjar]

LeventK:

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.

[1minManager]

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?

[Steve]

Not a bug because IFS() correctly returns a blank value, which is itself a value.

... - LIST("") is the correct solution.

[1minManager]

Is that the same with IF() too?