# 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?

• 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

• 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

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!