Unique value in a enumList column when concatenate

[alexandre-sabot]

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

[Marc_Dillon]

What is the intended result?

[Joseph_Seddik · Accepted solution]

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

______

List Addition | AppSheet Help Center 

[alexandre-sabot]

Perfect, thank you