Listing Unique values from multiple columns
Is there a way to list unique values from different columns (4 to be exact) by row?
More context:
- I have four different sheets from which I have to pull unique values for a column (column name is consistent across 4 sheets).
- I created a unique sheet with manual numbering and now have a sheet with four columns (for each sheet) that lists unique values per sheet for this column.
- Now, I want to combine all the values across four columns (unique values only) in a new column (no criteria involved) - this is where I am stuck.
- Steps 1 and 2 are what I did based on reviewing answers in the smartsheet community, open to other suggestions
Answers
-
Extend your numbers even further, then use the same method for grabbing the distinct values from a single column (I imagine an INDEX/DISTINCT/COLLECT) but instead of referencing a single column, reference all four that are in this secondary sheet.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!