Filtering values by V-lookup based on multiple column values
Answers
-
HERE is a link to a published sheet that contains the solution for parsing down a column from a list on a different sheet. My initial JOIN/COLLECT in String1 is going to be different because I pulled the data based on different criteria. The rest of the sheet though, you should be able to replicate for your sheet. This will parse the first set of data down your first column. Then you would set up another Comma and String column for your next list column, duplicate for your third list, etc. etc. All you would need to do is adjust your JOIN/COLLECT to pull the appropriate data.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 405 Global Discussions
- 216 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 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!