List showing blank items

AppSheet AppSheet Q&A
1

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

2

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

3

Hi Simon,

Does the following expression help

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

3 Likes
4

Awesome @Suvrutt_Gurjar thats done it

1 Like
5

@1minManager @Suvrutt_Gurjar
How about like this?

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

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.

7

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?

8

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

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

2 Likes
9

Is that the same with IF() too?