%Complete

Options

I am looking for a formula that will calculate % Complete based on two dates. I have been successful at getting this formula to work on projects that have already began but completed dates or not started dates are giving me a percentage that is negative or above 100. I would like projects that have not started to say "0" and projects completed to show "100". For example

Thank you for anyone who is able to support with this.

Best Answer

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

    Try this...

    =IF((TODAY() - [Screenshots for Job Aid Due Date]@row) / ([Go Live]@row - [Screenshots for Job Aid Due Date]@row) > 1, 1, IF((TODAY() - [Screenshots for Job Aid Due Date]@row) / ([Go Live]@row - [Screenshots for Job Aid Due Date]@row) < 0, 0, (TODAY() - [Screenshots for Job Aid Due Date]@row) / ([Go Live]@row - [Screenshots for Job Aid Due Date]@row))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!