Master Project Link Help
I am trying to create a master sheet with certain information from 20+ other sheets. Each row of the master sheet will be specific to one project with various dates that need to be tracked shown in each column.
Is there a way to make each cell automatically know which project to pull information from without linking each individual cell back to the project it is pulling info from? Like a way for each row to know what project to pull from and each column to know what cell in that specific project to pull data form?
Sorry if this is confusing. Thanks!
Comments
-
Hi Andrea,
I'm not sure I follow what you mean.
You don't need to link each individual cell because you can link the whole row/column or larger section.
I hope this helps you!
Best,
Andrée Starå - Workflow Consultant / Get Done
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.
-
Andree,
Not sure if that is what I need to do. Basically I have 20+ sheets with a whole bunch of information in them. Each of those sheets is set up from a template with varying dates/information inputted for each project. I want to have 1 master sheet that pulls the main info out of each of the 20+ sheets. I'm trying to find a way to tell each cell where it needs to be pulling from without having to go in and link each cell indidvually. I want each row to know it is assigned a certain sheet/project and each column to know which cell in that project to be pulling from.
-
Andrea,
Are you creating the 20+ sheets continuously or are they already created?
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.
-
They are already created
-
Ok. I think that the easiest solution is to cell link the sheets one by one.
How is the information structured on the sheets? Can you share the sheet or a screenshot?
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 443 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives