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

Find more posts tagged with

Accepted answers

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.