Unique value in a enumList column when concatenate

AppSheet AppSheet Q&A
1

Hello,

I have two columns, one is a list of campaigns already done [ID Campagne] and one other is the campaign in progress [ID Campagne Actuelle]

When the last campaign is done, I try to concatenate with all campaigns in [ID Campagne] column with this formula but it does not work

unique(list(concatenate([ID Campagne Actuelle], “,”, [ID Campagne])))

Any idea?
Thanks and regards,

Alexandre

2

What is the intended result?

3

UNIQUE( LIST([Campagne Actuelle]) + [ID Campagne] )

List Addition | AppSheet Help Center

2 Likes
4

Perfect, thank you

2 Likes