List showing blank items

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 :confused:

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("")

3 Likes

Awesome @Suvrutt_Gurjar thats done it :slight_smile:

1 Like

@1minManager @Suvrutt_Gurjar
How about like this?

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

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.

2 Likes

Is that the same with IF() too?