Is it possible to share 2 or more interconnected sheets such that there is a parent sheet and multiple child sheets and the parent rolls up the info on the child sheets, allowing any changes on either the parent or child shows up for the other users? The key is that this needs to be bi-directional like normal smartsheet functionality and allow the info to be truly shared.
use case
I am trying to create a master sheet (employee action items by department) that connects with separate sheets that each of my direct reports updates with his/her progress on action items. Both my direct reports and I should be able to add/remove rows on the list of items and it synchronizes between both sheets, no matter if I or the employee made the change. The goal is to be able to use these during my 1 on 1 meetings with direct reports and the employee only sees his/her sheet but my master sheet rolls up all the employee smartsheets. This will allow me to manage all the employee lists much more easily through 1 sheet instead of many others.
thanks for any guidance on this.
Jeff