Is there a way to add data to one sheet and have it automatically pull to another sheet?

Candace Haskell

I have two sheets, and they share a similar column, but only that one column is consistent between the 2 sheets. The column is called "record ID#". I am hoping there is a way that once I add a new record ID # to one sheet (Sheet #1), that record ID # can automatically populate on my other sheet (Sheet #2). Just the record ID# though - not the other columns of Sheet 1. I want this to be automatic so I am hoping I can use a column formula or something. I thought about vlookup or index/match, but I am not sure how that would work because I don't think I am matching anything

Andrée Starå

Hi @Candace Haskell

I hope you're well and safe!

You could use cross-sheet formulas combined with either a VLOOKUP or INDEX/MATCH structure to connect the sheets, and when you update the source sheet, it will reflect on the destination sheet.

You'd add an Aout Numbering Column in the Source Sheet and then add a so-called helper column in the Destination sheet and then number it manually and reference it in the Cros-Sheet formula.

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

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

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Candace Haskell

@Andrée Starå Thank you for your response. I think that makes sense. Could you tell me what you mean by "Aout Numbering Column"?

Andrée Starå

@Candace Haskell

Excellent!

Happy to help!

That was a typo. It should say Auto Numbering.

More info

https://help.smartsheet.com/articles/1108408-auto-numbering-rows

Make sense?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!