Welcome!

Consolidating identical project sheets

Hi all,

for each of our project we have built a simple scorecard that lists milestones / tasks on the left column, start/ end date, status, health. This scorecard is identically used for all projects since we have same deliverables for all our projects.

Ask: how can we have consolidated view for all our projects in one scorecard or report? using the report builder is not helping. Your urgent help is appreciated

Find more posts tagged with

Comments

p_bureau

Why is the report builder not helping ? It can consolidate a dynamic number of sheets if they are in the same folder.

As far as I know, you have only 2 ways to easily consolidate data with Smartsheet:

the report builder (wich is pretty cool)
the Live Data Connector you can use with Excel (and Power Query)

Best Regards,

Paul.

Paul Newcome

I don't know why report builder wouldn't be helpful, but another option would be to create a form where the data is entered. Then all forms submitted would be on the same sheet.

Mick Jordan

Add a "Scorecard" checkbox against each row in each sheet for the milestones concerned. Then build a report that just filters for those items where the checkbox is ticked.

Does that help?

Mick

I am trying to do exactly this but reports seem to be acting up, not refreshing or picking data from only one sheet when selected 3 identical sheets.

Any advice?

Paul Newcome

Apparently the reports function within Smartsheet was acting up a bit. Try again today?

Zak

Hi Paul,

The challenge is that report builder will list all the milestones by project vertically instead of pivoting; ending up with extensive excel files that repeats all milestones list for all projects

Sign in to join the conversation!

Quick Links

Trending discussions

Is it possible to edit an email list in an automated monthly report?
I have a monthly report I send out that has a long list of recipients. I know I can edit the recurrence of it being sent, but does anyone know of an easy way to just add or take out people that get my email without having to recreate the whole thing?
User Friendly Search
We would like to allow conference attendees to check themselves in using tablets at the conference center. I know there is a "find in sheet" magnifying glass in table view, but it is not super obvious, especially for non-Smartsheet users. Is there a better way for them to easily find their row among all the attendees so…
2 part automation delay question?
Greetings- I have a automation setup when I select the "status" column drop-down to "completed" I want the row info to be emailed to the contact to submitted it with a follow up then I want it to archive the row (aka move to another sheet). When I run the automation only 1 of the 2 requests happen. The archive happens…