Index Match in Helper sheets
Hi community,
I need some help implementing helper sheets. Here is what I'd like to do:
- I have a "helper sheet 1" with many many columns and I want to specifically extract information from only certain columns and put into "helper sheet 2"
- The "helper sheet 2" has those specific information in the cell within the needed columns
- There are 4 important columns I want to have, and they are called "Task", "analyst", "Lot number" and "Start Date"
- Sometimes the task is done by multiple "analyst" and on various "Start date"
Here is where I'm stuck and confused:
- I figured INDEX and MATCH is the way to go
- I have modified "Manage references" using the right click and linked helper sheet 1 and 2
- It seems to grab any of the "analyst" who has done it in the past or was assigned the "Task" but it doesn't seem to consider more than one analyst who could have completed the task.
- How do I have in each row the corresponding: task name, the analyst who did that task on that date, and the lot number of that particular task. All into "helper sheet 2" using the information that are in "helper sheet 1"
I would really appreciate the help. I've tried youtube videos and all sorts of google searches. I will follow up if additional clarity is needed. Thank you!
Answers
-
Are you able to provide some screenshots for context? Sample data is fine.
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!
-
-
I posted some screenshots here. Any assistance is greatly appreciated. Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!