Automatic Linear Percentage Complete Formula

Hello,


I am wondering if you can help.


I currently use Smartsheet for project planning.

I would like to build an automatic percentage complete formula. This formula should work off a linear progression line from Actual Start Date to Baseline Finish Date and the duration.

So an example of a task would be:

Actual Start: Now

Baseline finish: 10 Weeks from now

It is now week 6 exactly, then we should be 60% Complete.

Thank you,

Luke


Answers