Suggestion: If anyone gets the chance, I would like to be able to see the results that are concatenated using the UNIQUE() function, such that there is a “space” included after the commas.
It would be much clearer, and therefore easier to read!
Thanks,
Kane
Hi,
We will adjust our UNIQUE formula to allow users to define the separator they need. I’ll notify you once it’s online.
Thanks Amy,
That’s great news!
Kane
Hi Kane,
It’s now supported to specify the separator of your UNIQUE() formula result.
You can now use UNIQUE(value, “specified_separator”) to retrieve the value. Please note that the separator cannot be alphanumeric.
Great news!
Thank you very much! I will be making changes to my DB accordingly!
Kane