Use formula « NAME » for a Number list
The NAME function always returns the #ID and not the display name.
I need another function that could returns the display name.
If this function doesn’t exist, I’m looking for a solution to switch from a list format to a text format.
So I’ll be able to concatenate.
The difficulty is: the format list used is different from the one in the column <<applies to>>:
Thanks in advance