Formula for % Complete


Is there a way to calculate % complete based on Start and End dates?

Best Answer

  • ✭✭✭✭✭
    Answer ✓

    Are you asking about forecasted completion?

    If Start Date is 0% and End Date is 100% what are you evaluating to determine the %

    Are you thinking Start Date 1/1/2021 and Forecasted End Date 1/1/2022 and based on today's date we are 12% along that path?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!