formula for the %completion in parent

Ray Smart

Hi All, 

I am trying to replicate the %completion formula in googlesheets in order to understand the value of a project based completion of the various subtasks.

Does smartsheets have this ability inherently? 

The project guys always think they are further along on the project than they actually are and this is artificially inflating revenue and dragging out the project timelines.

I want to be able to go through each subtask individually and challenge them with the time left to complete as a cost versus the revenue that is available to be recognised on the project.

A formula to replicate the %completion of the various parents (outside of editing the actual smartsheet) would be super helpful.

 

Any thoughts?

 

Regards, 

Raymond

 

 

 

Andrée Starå

Hi Raymond,

Is this what you're looking for?

=SUM(CHILDREN()) / COUNT(CHILDREN())

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant @ Get Done

Paul Newcome

=AVG(CHILDREN()) works too...