How to efficiently link data from one sheet to two other sheets

Tyra Skinner

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.

1. Created a form on the Master Sheet.
2. 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.

Andrée Starå

Hi @Tyra Skinner

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: 

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

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!

Tyra Skinner

Would you happen to have an example of how that would work? This would be my first time using Index/Match

Andrée Starå

@Tyra Skinner

I'd be happy to share an example. 

Please send me an email at andree@workbold.com, and I'll share it with you.