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!
Best Answer
-
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!
Answers
-
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?
-
Are you able to provide some screenshots for reference?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 301 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!