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.
One Sheet with Many Projects vs. Many sheets with One Project?
We're new to Smartsheet and our web and content team are going to have multiple tasks that are going to be repeated again and again. We're going to create a checklist of steps for each one, for example, steps for creating an e-book. Since we're going to be creating lots and lots of e-books, should we create a new sheet every time, or create one sheet with the checklist and just copy and paste it below the previous e-book on the same sheet that we would call "E-Book Checklist"?
Comments
-
Hi Goldensamy,
If your checklist is rather long I would suggest creating a template for the checklist and generating a new sheet for each e-book.
If your checklist is not very long you could create hierarchies for each e-book and copy and paste the checklist as children rows to collapse and make the singular sheet more manageable.
Here is a link to creating templates and also hierarchies:
https://help.smartsheet.com/articles/522123-creating-using-templates
https://help.smartsheet.com/articles/504734-hierarchy-indenting-outdenting-rows
Hope this helps,
Brandy
-
Because you said there would be many E-Book projects, here are a few suggestions based on my experience.
- One sheet for each project
- Each sheet has a Status column for rows in the sheet (Not Started, On Track, Off Track, On Hold, At Risk, Complete)
- In addition, each sheet as a Project Status column for the status of the entire sheet. (Active, Cancelled, Complete)
- Only change the Project Status in the 1st row.
- All of the children rows should have the formula
- =$[Project Status]$1
- Use the 'Project Status' column in Reports to mine for data
- Show me the following on all sheets where Project Status = Active
- All Open Tasks
- All Past Due Tasks
- Open Tasks by 'Current User'
- Show me the following on all sheets where Project Status = Active
EDIT: Thank you, Mike! He brings up a very good point below. Reasons I see for going with one big sheet.
- You want summary data across projects
- Very few tasks per project (less than 20)
- Projects are related in some manner.
- ???
-
I would agree with what each person said here. however we have a 14 row process for course creation in our university and we created a sheet per program. A program may have 20+ courses in it. They roll-up so its easy to get to what you want. Using indents you can roll up the info as needed, plus you can create summaries from the data on the children.
-
Since there will be so many e-books, I would also recommend a sheet for each (that way you can export old E-book Checklists if needed), and creating a sheet to use as a template (that way if anything changes you can edit it easily). I feel like this makes it a little more user friendly, while helping to avoid project confusion if you have several at once... especially if you use Card View or Gantt Charts.
If you have different customers / categories / etc for each E-Book, then one sheet allows you to keep them individually organized. E-Book Workspace ---> specific folders.
Like Mike and Kris said, if there aren't many tasks per checklist then one sheet with hierarchies might be your best route.
Also, like both said, creating a Report including all E-Book Sheets would be VERY helpful.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives