Automatic Linear Percentage Complete Formula
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.