Reference column in multiple sheets to look up information

Line Ekanger

Hi!

I've been researching this for quite a while, but it seems I can't find a solution on my own. Hopefully, some of you have encountered the same type of issue, and will be able to point me in the right direction.

I'm trying to create multiple sheets to help my team keep track on our projects, and have created a mastersheet where most of the information will be updated. From this sheet, I'd like to be able to create sheets that extract information and are able to point information back to the mastersheet. (I find the sheet summary-reports will not give me exactly what I'm looking for.)

All our projects come with a unique order number, which I'm trying to use as a link between the sheets, but I keep getting circular reference-errors when I work in my associated sheets as I have used cell linking to make sure the order number-list is updated.

Is there any way to update the list of order numbers from the mastersheet to the associated sheets, while still being able to use the VLOOKUP-function to extract information back and forth between the different sheets? Or will I have to start each use of the associated sheets with copying in the order numbers from the mastersheet?

Thankfull for all help!

Best, Line

Andrée Starå

Hi @Line Ekanger

A solution that probably would be perfect for this use-case is the premium add-on, Data Uploader, but it depends on how many sheets you'll want to "sync" the order numbers too.

Is that an option?

More info: 

https://www.smartsheet.com/marketplace/premium-apps/data-uploader

I hope that helps!

Be safe and have a fantastic day!

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!

Line Ekanger

Hi!

Thanks for the tip!

It might be an option for adding new orders to the mastersheet, but I'm not exactly sure how it will help keeping my other sheets updated? Or is it possible to import the same column from date uploader in to multiple sheets at the same time?

Best, Line

Andrée Starå

@Line Ekanger

You're more than welcome!

Data Uploader is used to update the Dropdown lists in your use-case, but maybe I didn't understand your need correctly.

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Line Ekanger

@Andrée Starå

Thank you so much for trying to help. I've sent you an email and hope you'll be able to give me some insight on my problem :-)

Best, Line