Reference column in multiple sheets to look up information
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
Answers
-
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:
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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
-
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)
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!