Update a referenced sheet without individual column formulas

noshiro

HI,

I have a master sheet that feeds data into a helper sheet. I want the helper sheet to automatically update whenever the master sheet data changes. Is there a way to sync all columns based on a unique row ID (to avoid pulling in the duplication of rows), without having to write individual formulas for each column?

I've been using INDEX MATCH for another sheet, but this master sheet is vast and would not want to create INDEX MATCH for each column.

Lisa LS Kennedy

Do you have access to DataMesh?

noshiro

Hi @Lisa LS Kennedy

No I do not have DataMesh

Andrée Starå

https://community.smartsheet.com/discussion/138322/update-a-referenced-sheet-without-individual-column-formulas

Hi,

I hope you're well and safe!

If the order never changes, you could use a VLOOKUP structure instead.

Another option could be to have one or more helper columns to collect data together, use INDEX/MATCH to the second sheet to some helper columns, and then split out the data from those.

Make sense?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!