Setting up a Program with multiple project

Hello! I am fairly new to SmartSheet and am looking for some advice on how to set up a program management sheet.

In short, I have multiple sites which have various tasks I need to track of. I would like to organize by site and task or at least be able to pull a report (or look at a dashboard) that will indicate what is happening at each site on any given day.

Any help would be greatly appreciated.

Thanks in advance.

Find more posts tagged with

Templates

Sheets

Accepted answers

All comments

Andrée Starå

Hi,

It sounds to me that a report that that looks at the different sites would work. Cell linking is another option. I would need more information to be able to give you a more precise recommendation because it all depends on your specific needs.

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant / Get Done

Kamy

Hi,

I am totally new, and curious about Smartsheet abilities. I had the same question as above about program dashboards. I.e., having the ability to create a dashboard or generate reports that integrate data from different projects when each project is managed by a different user from the same organization (i.e. project managers)

Many thanks,

Kamy

Lachlan Stead

As Andree mentioned, a report is your best option to collate data from across the organization, especially if the structure is uniform.

Genevieve P.

I agree with both @Andrée Starå and @Lachlan Stead!

Here's a free webinar on Reports to help you get started: SmartStart: Reporting

I will note that you'll need to be on a Business or Enterprise plan in order to bring multiple sheets into one Report.

Cheers,

Genevieve

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.