# 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"?

• You would use something along the lines of...

=(TODAY() - [Start Date]@row) / ([End Date]@row - [Start Date]@row)

• 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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!