Managing Content Data for Multiple Teams

jesiwicks

Hi, Looking for suggestions.

I am trying manage content from multiple teams.

I am currently using a master Smartsheet called my "Content Inventory" with the columns being details about the content, type, links to gated/ungated assets, links to working documents, keywords, metadata, etc—all the good marketing details for each piece of content.

From this "Master Content Inventory" I am making "Dynamic Views" with only the relevant information for our sales guys to see all of the content by type or team. This has been really helpful in getting my sales guys to self-serve when looking for content for their projects. This also allows the stakeholders to see ALL of the content across the company by type.

The issue I am having is that we now have marketing teams for each major product/service who are managing their own content and that content is getting lost in a silo within those departments. I don't want to give access to my main content inventory to all of my marketing teams to input content directly because that would be too chaotic. I do, however, want transparency so that I can see all of the content each team has made in one Master Content Inventory.

Is there a way to create a sub-Smartsheet for each of my teams with all of the same columns as my Master and have the data from those sub-Smartsheets automatically show up on my Master?

The purpose of this is so that each team can manage their own data without getting overwhelmed by the giant master, but I can make dynamic views available to Sales from the one Master Content Inventory source. Also, this would allow me to have a true library of content for the whole company.

Any other solutions are welcome.

Thanks for your help,

Jesi

Andrée Starå

https://community.smartsheet.com/discussion/122119/managing-content-data-for-multiple-teams

Hi,

I hope you're well and safe!

Have you explored the Premium App, Brandfolder?

Is that an option?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

https://community.smartsheet.com/discussion/122119/managing-content-data-for-multiple-teams

Another option could be to have Reports connected to Dynamic View instead.

Would that work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

jesiwicks

https://community.smartsheet.com/discussion/comment/436575#Comment_436575

To my knowledge there is not a way to connect reports to Dynamic views

Andrée Starå

https://community.smartsheet.com/discussion/comment/436631#Comment_436631

Fortunately, you can use Reports with Dynamic View.

Boost collaboration even when you cannot share the underlying sheets or reports with the Dynamic View premium app. Share only what is needed to the right people at the right time for viewing or editing.

Would that work?

✅ Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!