I am trying to pull a list of unique values from one sheet to another
Barb R
✭✭
I am trying to pull in a list of distinct values to sum. I have a sheet with a project number, date, and a value (project id, date, amount) and I have merged all of those together for a helper column. Now I want to pull that helper column's distinct values into another sheet once. The original sheet may have the values listed multiple times.
Answers
-
When you say "distinct values" which column is this based on? The value itself, the project number, etc.?
School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!
-
The helper column where I have conjugated the values.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 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!