Manpower formula

Hello,

I do not know if this is possible, however it would make life so much easier if it were.

Can I set up a formula in one column to calculate how many people (man power) I need on a specific job based on the start and end date (when the job needs to be completed), the budget hours (hours given to complete the job) and the fact that they will be working an 8 hour work day.

This way, when I am planning a job, I can simply input my start and end date for the project, cross checked with the hours I have been budgeted to give me the number of crew members I need on the job each day.

If this is possible, what is the formula and how do I make it work?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!