Unique list of text strings

darkmatter
darkmatter âś­âś­âś­âś­
edited 03/09/22 in Formulas and Functions

i am looking for a way to return the unique text strings from a range. In Excel, this can be done using the formula '=UNIQUE(A:A)'. Is there an equivalent in Smartsheet?

e.g. Column A:

Apple

Pear

Orange

Pear

=UNIQUE(A:A)

Apple

Pear

Orange

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!