LABOR EFFORT PROJECTION

Options
Simon Martinez
edited 09/09/22 in Formulas and Functions

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

  • Genevieve P.
    Genevieve P. Employee
    Answer ✓
    Options

    Hi @Simon Martinez

    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

  • Genevieve P.
    Genevieve P. Employee
    Answer ✓
    Options

    Hi @Simon Martinez

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!