ways to link sheets for teams with different functions
Hi all,
Newbie here, pardon the newbie question. Am helping build out our SmartSheet workflow and presence for a marketing and comms team, but don't have full license permissions and am trying to learn what I can without being able to kick all the tires.
My org has a comms team (primarily writing stories for our website and also producing video), a media relations team (writes press releases and pitches stories, some of which have been on our website but others have not), a social media team (which picks up a lot of stuff from our website, but also plans its own social-only content), and a marketing/brand team (which designs/writes/runs ad campaigns on social, online, etc.)
Mostly we are using SS as an editorial calendar of sorts, with simple status updates on each assignment or story (e.g. idea only, assigned, in progress, ready for publication) and to capture story and project ideas as they come in.
There is a desire on the part of leadership to see "everything at once" -- somehow this has been translated as "build one sheet that needs to capture all project info for all teams." But my gut tells me this is not at all the way it should work-- right?
I would think the best practice for our group is building multiple sheets -- say one for each team above -- and then linking them in some way via reports/automation so that a user could see things like all dates of all projects, etc. Or linking them such that they share information/data... am I right? Would this need to happen in different workspaces or just a single workspace?
I'd be most grateful for any tips and guidance as I need to convince folks with fancier titles that this is the way to go. Thanks!
Answers
-
I hope you're well and safe!
I'd recommend starting to use one sheet to start and combine that with reports/filters if needed. If that doesn't work, I'd recommend exploring creating multiple sheets.
Make sense?
Also, have a look at the Solution Center for examples of templates already created.
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thanks very much Andrée. Again, not having full permissions is a bummer since I can't for instance create new "test" sheets from the template gallery. But it helps to know that starting with one sheet is the way to go. Follow-up question -- is there some kind of user community where people share their custom SmartSheet templates? I have been using Trello and their user-generated templates were of great help to me when I was learning to use it.
-
Excellent!
You're more than welcome!
You have a lot of Smartsheet developed Templates in the Solution Center.
✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 463 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives