Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Creating a Master Sheet Composed of Dependent Dept Sheets // Sheet Linking // Sub-Sheets
Hi Community -
Looking to crowdsource the best method of creating a Master Sheet (think: Company ALL) composed of smaller Department Sheets (think: Marketing, Development, etc).
The ideal set up here is that while only I may have access to the the "Company All" the dept heads have access to their respective Department Sheets and as they make updates to their respective sheet (Perhaps adding a new row/task or changing dates) it autosyncs into the "Master Sheet".
The overall function is setting up a Master Sheet thats really just composed of 4 to 5 different "Sub-sheets"... does this make sense? Is there a better way to go about this or think of this type of set up?
My understanding of simple "Cell-Linking" doesn't seem appropriate because while it may reflect the change of cell information it wont reflect new rows/data being added; it seems what I'm looking for is more like "Sheet Linking". Additionally, I looked into Zapier links, but that only seems to reflect additions made to the very end of the existing smartsheet/google sheet... not if a row is added to a specific sub-objective in the middle of the "sub-sheet".
Thanks for the guidance and brainstorming here Community!