% 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?
Answers

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:
 Add a planned percent complete column with this formula: =NETWORKDAYS([Start Date]@row, TODAY()) / NETWORKDAYS([Start Date]@row, [End Date]@row)
 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/juliefortneypmpsmartsheetpartnerlssblackbelt
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.8K Get Help
 65 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!