LABOR EFFORT PROJECTION
I need help figuring out how to calculate how much labor cost for a particular task will be at the end date based on 
 column 1  start date
 column 2  end date
 column 3  current labor spent
Initially I'm thinking I need to take the current labor spent to date and divide between today and start date. then multiply by overall duration?
The idea is to be able to figure out if the labor will be more than the budget at the end date
Does this look right?
Best Answer

Your logic makes sense to me!
For your formula, you won't need the SUM() at the beginning. Instead, you can just enclose the division in parentheses before the multiplication:
=([labor spent to date]@row / NETWORKDAYS([start date]@row, TODAY())) * [duration days]@row
I used @row instead of a row number so you could set this as a Column Formula if needed.
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now
Answers

Your logic makes sense to me!
For your formula, you won't need the SUM() at the beginning. Instead, you can just enclose the division in parentheses before the multiplication:
=([labor spent to date]@row / NETWORKDAYS([start date]@row, TODAY())) * [duration days]@row
I used @row instead of a row number so you could set this as a Column Formula if needed.
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now
Help Article Resources
Categories
Check out the Formula Handbook template!