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

Candace Haskell
edited 05/24/22 in Smartsheet Basics

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