Project Completion %

Sarah Killins

Hi!

I am pretty new to Smartsheet and am building my first project template.

I've got tasks in rows 21-169 and I am trying to build a formula to calculate the total completion of the project, taking into account the durations set for each row. The rows are also indented into phases and milestones.

Any help or direction is appreciated.

Thanks!

Andrée Starå

Hi @Sarah Killins

I hope you're well and safe!

I recommend activating the Dependencies feature because the % Complete will automatically calculate.

https://help.smartsheet.com/articles/765727-enabling-dependencies-using-predecessors

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Sarah Killins

Hey @Andrée Starå

Thank you for your answers, I hope you are well and safe too.

I have dependancies and durations enabled, and built out, and I'd like the % completion for all of the tasks (like an overall project completion %) to display at the top of the project sheet.

Any help is greatly appreciated!

Thank you,

Sarah

Andrée Starå

@Sarah Killins

Happy to help!

You need to add a top hierarchy or make the top row a parent row.

Make sense?

Did that work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!