Calculate % complete based upon start and end dates?

Hello, does anyone know how to calcuate the % complete for a project based upon it start and end date? I have projects where my resources are "consulting" and I'd like to have a way to see the % complete of the project when I roll it up in a project overview dashboard.

I tried using the traditional "yearfrac" formula utilized in Excel but this doesnt appear to be supported.

Thanks for your help!

Mike

Find more posts tagged with

Calendar View

Formulas

Reports

Conditional Formatting

Enhancement Request

Comments

Shaine Greenwood

Hi Mike—one important note on this is that if you have dependencies enabled in your sheet, there isn't currently a way to place custom formulas in the % complete column as it's being used to calculate the weighted parent roll up functionality.

If you don't have dependencies enabled in your sheet, you'll need to create a custom formula that calculates the percentage for you in a manner that you see fit. Although we don't have a YEARFRAC function in Smartsheet, I'd recommend checking out our Help Center to see what you can come up with: http://help.smartsheet.com/articles/775363-using-formulas