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


  • Ray Lindstrom
    Ray Lindstrom ✭✭✭✭✭✭


    Not sure I'm following. Are you saying you would like to know the following?



    Start Date = 1/1/23

    Finish Date = 1/4/23


    Today's Date = 1/3/23 would mean %Estimated would equal 75%


    Is that right?

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    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!