Plan Percentage Complete
Hi, In Ms Projects there is a calculation to measure your actual completion percentage vs your planned percentage completion %, does anyone have a formula that could do the same.
Be safe,
Cheers
Answers
-
You would use something along the lines of this to determine your planned:
=NETWORKDAYS([Start Date]@row, TODAY()) / NETWORKDAYS([Start Date]@row, [End Date]@row)
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!