I'm trying to use INDEX/COLLECT to bring back more then one result in the same box
I'm using INDEX/COLLECT
=INDEX(COLLECT({TMPIT}, {TM}, Login@row, {TMPIT}, ="Dock Stocker"), 1)
This works for 1 result.
If a login has more then one result, how do I get those result all in one box?
example
I want to search the list and see that awhit has all of these machines
I would like the result to be
Also if the login does not have any of these to get the result None
Answers
-
Good Morning @awhitmore,
You will be able to achieve this result by making the collectable data a multiselect dropdown
=IF(JOIN(COLLECT({data}, {login}, HAS(@cell, Login@row)), CHAR(10)) <> "", JOIN(COLLECT({data}, {login}, HAS(@cell, Login@row))), "None")
There is definitely a shorter way of doing this -- but the concept is the same. use JOIN(COLLECT( to have a delimiter between the data you are searching for based on the login column, and return "None" if the login does not have data
Hope this helps
Sincerely,
Jacob Stey
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!