Return a unique list from a column

Jim McWilliams

I have a form feeding data into a sheet. One of the columns being populated is for part numbers. I want to return a unique list of part numbers that have been entered into the column. I can't figure this out based on the posts I've found on tis topic. I'm fine with using helper columns or whatever else may be needed. thanks in advance.

Jim McWilliams

Got it working using Paul's thread! Appreciate the help!

Genevieve P.

Hi @Jim McWilliams

Where are you wanting to return this list, in the same sheet or in another sheet?

One option would be to create a Report and then Group by the Part Number.

Another option would be to use a combination of JOIN, DISTINCT and COLLECT to bring all the unique values into one cell.

However if you're looking for a solution to pull the unique list into another sheet, one in each row, Paul has a great answer in this other thread:

https://community.smartsheet.com/discussion/90798/using-distinct-function#latest

Cheers,

Genevieve

Jim McWilliams

Hi Genevieve,

I'd like to pull it into another sheet. I'll check out the report option and the thread from Paul. thanks

Jim McWilliams

Got it working using Paul's thread! Appreciate the help!