% Complete Formula

Melita Clark

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

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