Project Rollup Metrics (sum of all project durations)

I have a master sheet that rolls up metrics from my projects for reporting on various KPIs to my leadership. I need to sum duration, but when I link the cell from the sheet it comes over as (ex., 43d). The sum doesn't acknowledge the d, so I am unable to sum the total of all days for a project. Thanks,

Find more posts tagged with

Project Management

Comments

Andrée Starå

Hi Elizabeth,

There are a few ways to solve this, but the easiest would probably be to deactivate Dependencies (Project Settings) on the metric sheet and add =SUM(CHILDREN()) to the parent row(s).

Would that work?

Have a fantastic week and let me know if you have any questions!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

FactionPMO

Hi:

Unfortunately because this is a link I am unable to alter the formatting. The (d) is preventing calculations for processing and I can't identify a formula that would let me work around that. The intention is to provide automated rollups and the total duration of all projects in the pipeline. Thanks!

Andrée Starå

It should work!

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Best,

Andrée

ShelbyT

Hi FactionPMO,

Have you been able to figure this out? I'm also having the same problem. I'm trying to capture metrics for the average time of all projects in each stage.

Thanks!

Sign in to join the conversation!

Quick Links

Trending discussions

Sheet Access report
Hello. Me and my team are doing an audit of users who have access to edit items in our account and one of the reports we're using is the Sheet Access report under the User Management section of the Admin Center. However, we're running into some weird things. When we dig into the Sheet Access report, we sometimes notice…
Does sheet access require new users to create a smartsheet account?
No License required I am sharing a published link, no license required to a group of people. The goal is for them to be able to edit the sheet. Would each member be required to create a smartsheet account? Please, is there a way for them to access my sheet without having to create an account? Many thanks!
Backspace, enter and delete keys not working...
This has happened a couple of times before. However, when trying to update a form or even a field in the smartsheet, I am unable to use the backspace, enter or delete key. I use Google browser, however I wasn't sure if it was Google, so I switched to Microsoft Edge. Still not working. Also, I tried using the backspace,…