% Burn Rate Verus dates

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
    Julie Fortney Overachievers

    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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!