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.
Insert Row: Automatically Links Cells
I am trying to figure out a way to best organize my project tracking...
For example, my company has four big projects coming up, let's call them projects A-D. We have organized our sheets by project, and then created various sections within the sheet for each team working on the project, with sub-sections for task categories and the respective sub-tasks. Let's call these teams Team 1-7.
My ultimate goal is to share with Team 1 ONLY the categories and tasks that apply to them across all four projects. So what I thought would be best would be to create new sheets, for Teams 1-7, copy the cells from Projects A-D that pertained to their tasks, and then link the cells so that changes Team 1 makes to the Team 1 sheet also shows up on the Project A sheet (or any sheet for Project A-D).
The problem comes with inserting rows... Say I only created tasks that I was aware of. When a member of Team 1 reviews the sheet, they see I forgot four tasks. When they add these four tasks to the sheet "Team 1," (they do this by creating new rows), those new rows do not link to the sheet "Project A".
This was also the issue when I was considering using the "update request" feature; you can send certain rows from your sheet to collaborators so they can only see those certain rows, but I don't think the update request feature allows you to add rows. Which is functionality I need.
Can someone explain a solution that may help? If this is not possible, I strongly suggest adding functionality in an update where rows added from a source sheet - under a linked section - automatically are added to the sheet the cells were linked to.