Using Index/Match to pull column names where values =1

I currently have one SmartSheet set up to track viewership of multiple learning courses. Each learning course is its own column heading. ID numbers comprise my primary column. When someone enters their ID into a form they watch the video & a new row populates with a 1 in the column relating to which course they viewed, & leaves all other columns empty (because they relate to other learning courses, not viewed by the user).

I would like to cross reference ID numbers from a second sheet with an Index/Match formula, and have it pull back to me which videos (Column Headers) those matching ID numbers watched. Is this possible?

Thanking you in advance!

Find more posts tagged with

Accepted answers

iamsteve

After working on this the past 4 hours, I realized that I can't pull column names, & potentially multiple column names using index/match, or any formula for that matter...unless I am mistaken? So I reluctantly pulled the data from each & every Learning Course using index/matching to the ID numbers on my secondary sheet. Now I have the data I need, organized the way I need it, to pass up the ladder.

Thank you anyways Paul 🙏

I'm sure I will need some expert assistance soon enough!

All comments

iamsteve

Is my best workaround to add in a new row 1 with all of the column names listed (the titles of the Learning Courses) & Index that info where my ID numbers match & a 1 is entered in that particular column?

Paul Newcome

Are you able to provide some screenshots for reference?

iamsteve

Thank you anyways Paul 🙏

I'm sure I will need some expert assistance soon enough!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.