Unique list of text strings

darkmatter

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

Steven Evans

Looks like DISTINCT() is what you need, some good refs here:

https://community.smartsheet.com/discussion/71496/help-with-distinct-function

Steven Evans

Looks like DISTINCT() is what you need, some good refs here:

https://community.smartsheet.com/discussion/71496/help-with-distinct-function

darkmatter

thanks - great tip!