How to efficiently link data from one sheet to two other sheets
Hello,
I'm trying to link data from a master sheet to two other sheets. Here is what I tried so far, but it's not working.
- Created a form on the Master Sheet.
- Tried Cell linking the master sheet to two other sheets. However the problem that I have is that because I am already using cell linking on this Master sheet to feed into a metrics sheet, when I add a new submission on the Master sheet, it goes to the bottom of the sheet at Row 50 even though there are many blank rows above. See screenshots below to understand what I mean.
Goal: I want the gray columns in the Setup tracker to be populated by a form and be inputted into two additional sheets.
Answers
-
We could use a VLOOKUP or combination of INDEX/MATCH to collect the values to the other sheets.
Please have a look at my post below with a method I developed that you could use for your need as well.
More info:
Would that work?
I hope that helps!
Be safe and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Would you happen to have an example of how that would work? This would be my first time using Index/Match
-
I'd be happy to share an example.
Please send me an email at andree@workbold.com, and I'll share it with you.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K 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
- 304 Events
- 34 Webinars
- 7.3K Forum Archives