How to Return Values from another sheet in deliminated format?
Hi Smartsheet community,
I want to be able to return values in Sheet 2 in deliminated format. I have attached the diagram for reference.
Please suggest the appropriate function or way to get the output?
Thanks,
Binika
Answers
-
You can use a JOIN(COLLECT formula to collect together the different values in one cell. However the tricky part will be defining the Names that you're looking to bring the Cost back from. Do you have a way of identifying the "group" of Names in both sheets?
For example, if you have an identifier that tells you that you want A, B, C, and D together, you can use this as criteria in your COLLECT function.
In my example, I have a group identifier saying "Group 1" or "Group 2" to show what letters to collect in the "Name" of Sheet 2, and then what Cost to collect in the corresponding cell. Does that make sense?
To help further, it would be helpful to see screen captures of your actual data, but please block out sensitive information.
Thanks!
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thanks for your help Genevieve P. This helps :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!