How to populate a column in a sheet based on a column from another?

Beginner here.

I want to populate a column with the names of people in a new sheet, with the data to be taken from a column in an existing sheet. In this sheet, the names are given in the column multiple times over since it reflects each of the accounts these people have.

I'd like each individual name to only be included once each in this new column and for this column to auto-populate based upon the existing one.

What's the best way to go about this?

Thank you for any help.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!