I'm trying to use INDEX/COLLECT to bring back more then one result in the same box

awhitmore

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

SteyJ

https://community.smartsheet.com/discussion/109812/im-trying-to-use-index-collect-to-bring-back-more-then-one-result-in-the-same-box

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