formula for the %completion in parent

Ray Smart
Ray Smart
edited 12/09/19 in Formulas and Functions

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?








Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!