Incoming and outgoing project sheets

I am looking to implament project controls as below

One (1) workspace
All project sheets (no sub folders)
Project control Sheet
Reporting (at risk tasks, high priority tasks, hours per resource)

As projects start (need to be seen on the Project Control Sheet) and end (no longer are needed on the project control sheet), what is the best practice to automating new projects into this hierarchy?

Intent is for new project sheets to get filled out, which will then trigger:

new project line within project control sheet
updated reporting

Thanks,

Find more posts tagged with

Workspaces

Automations

Project Management

Accepted answers

All comments

Stefan

Hi Michael,

Smartsheet Control Center (SCC) provides the automation you describe.

https://www.smartsheet.com/marketplace/premium-apps/control-center

With SCC you can use an intake sheet for project requests with basic data, have it approved there and then use a template filled with data from the intake to provision a new project sheet to your defined workspace. SCC also updates existing roll up report sheets etc.

If you reports are configured to look into the whole workspace, adding or removing a project sheet will automatically reflect in the reports.

SCC also allows to archive projects, thus removing them from summary sheets etc.

Hope this helps

Stefan

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.