Linking Sheets - Master sheet with multiple related sheets

Hi!
I am looking to create a master sheet that contains personnel data elements used by multiple teams with different needs. The master sheet should allow data entry of new attendees while also pulling new entries from a related travel sheet.
Example:
Master Sheet Admin is aware of a new registrant and manually adds to the master sheet. That entry would then be visible on the travel sheet (accomplished with cell linking) so the travel department can take action and update the travel elements that will link back to the master sheet.
Additionally, the travel department may be aware of the registrant first and would add the new registrant in the travel sheet which would then add the new registrant to the master sheet.
How do I set the sheets up to allow for new entries in either sheet? The cell linking will be reversed depending on which sheet the information is entered in first.
Do I create two sections in both sheets using the indent feature and then format the cells under the two sections to point the correct way?
Is that the easiest way?
Thank you!
Comments
-
Hi,
Have you thought about using a report instead?
Hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thanks for the response. I think I leaned toward using sheets with cell linking because of some of the editing limitations with reports (which I could be wrong about). I'll revisit, though, and see if that will work.
Thanks again!
-
Happy to help!
Let me know if you have any questions!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.