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! Go to Solution.
UNIQUE( LIST([Campagne Actuelle]) + [ID Campagne] )
______
What is the intended result?
Perfect, thank you
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |