JOIN DISTINCT CHAR(10) List on Sperate Rows

A Rose
A Rose ✭✭✭
edited 10/27/22 in Formulas and Functions


I have the following formula which collects a list of a dropdown column, and removes duplicate values, is there any way that the returned list of values should be on separate rows of this column formula?

=JOIN(DISTINCT(Dropdwn:Dropdown), CHAR(10))

Thank you,


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!