% Burn Rate Verus dates

tina.hutchinson52776

Please kindly advise on how I can calculate the % burn rate versus dates.

For example, Task A1 has a duration of 2 days and the project 'Project A' is on day 2. It has been assigned to 'Joe Bloggs' whose allocation on Task A1 is 100%, but the % completion is less than 50% - at (assuming that Joe Bloggs will spend 50% of his time for each of the 2 days, yielding 100% completion). What formula would I need to flag a delay in the schedule showing the task as well as the project is at risk? Also what column would I put this formula in?

Julie Fortney

Hi @tina.hutchinson52776,

To confirm, do you want to flag a task if the planned % complete as of today is greater than the actual % complete, meaning the task is behind schedule?

Here's a suggestion to do this:

1. Add a planned percent complete column with this formula: =NETWORKDAYS([Start Date]@row, TODAY()) / NETWORKDAYS([Start Date]@row, [End Date]@row)
2. Add a symbol or checkbox Delayed column (I used the flag checkbox) with a formula such as =IF([Planned % Complete]@row > [Actual % Complete]@row, true)

The allocation just refers to what % of Joe's days between the start date and end date would be spent on that task, so we can ignore that column if my assumption above is correct.

www.linkedin.com/in/juliefortney-pmp-smartsheetpartner-lssblackbelt