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.
Automated linking of added rows
I seem to have a major problem here and hope for you expert advice.
My situation is as follows:
1. Team A and team B work collaboratively in Masterfile on first phase of the project with over 200 rows from all countries.
2. Team A also works with the other 7 country teams on a second phase of the project.
3. All teams cannot work together in the Masterfile as it has sensitive information.
4. Team A needs to see a comprehensive overview on each records taking information from the Masterfile and the country file.
I would link the core cells from the Masterfile to 7 country files but the problem is that team A might be adding new rows into Masterfile and linking doesn´t work automatically so those rows won´t appear in the country files for country teams to pick them up and continue phase two.
At the same time I am not convinced of having these rows linked via creating the Report as it will mean that I need to create 7 country reports and information from these country reports needs to feed the Masterfile too and it will be a big puzzle to solve in case something will go wrong..
What are your thoughts? Is there any turnaround for this case?
Thanks in advance.