Announcements
The Google Cloud Community will be in read-only from July 16 - July 22 as we migrate to a new platform; refer to this community post for more details.

Unique value in a enumList column when concatenate

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

Solved Solved
0 3 474
1 ACCEPTED SOLUTION

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

______

List Addition | AppSheet Help Center 

View solution in original post

3 REPLIES 3
Top Labels in this Space