% Complete Formula


I know I'm totally wrong, cause it's not working :)

If I want to say take start date and find the difference from today's date and then divide by duration and place in % Complete column - how do I formulate that in smartsheet ? Thanks in advance!


  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭

    The formula goes into the %Complete column. Users shouldn't also be manually entering in %Complete in this column - manual entry will overwrite the formula.

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

    This may return negative values sometimes. If you wanted it to always be positive we would look for the Absolute value:

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!