How can I add a colum with the Estimated percentage of progress
Currently, I have my percentage of " completed work". However I would like to know , how can I calculate the " estimated percentage of progress".
I mean. Today in one activity I have as "%Complete" an 80%, however accoring to my work plan by today in theory I should have that task at a 100%. How can I add that column to calcule the "%Estimated"?
Best Answer
-
You would use something along the lines of...
=(TODAY() - [Start Date]@row) / ([End Date]@row - [Start Date]@row)
Answers
-
Not sure I'm following. Are you saying you would like to know the following?
-----------------------------------------------------------------------------------------
IF...
Start Date = 1/1/23
Finish Date = 1/4/23
Then
Today's Date = 1/3/23 would mean %Estimated would equal 75%
-----------------------------------------------------------------------------------------
Is that right?
-
You would use something along the lines of...
=(TODAY() - [Start Date]@row) / ([End Date]@row - [Start Date]@row)
Help Article Resources
Categories
Check out the Formula Handbook template!