If then formula? or alternative
Smartsheet novice here.
I am attaching an image but what I am truing to achieve is this.
I have a product that takes 1 hour to install per unit. my team can install 8 per day so 1 installationday. however if the client orders 12 units, it will take 12 hours to install which would be two days, 40 units would take 5 days… I would like to put in a formula that will calculate the installation days based on hours to install cell. If 5 units, 1 day, if 12 units, 2 days, if 40 units, 5 days…. it's all based on 8 hour day.
I seems simple but I can't sort. Any ideas? Thanks!
Best Answer
-
If 5 lights is a 5 hour installation then that is 5 units at 1 hour each and 8 hour days then that is
5x1 = 5/8 = 0.625 round up = 1
If you know the number of units and hours per unit - multiply those together - gives total hours
Then divide total by hours per day to get total days
Round up to get whole days.
Answers
-
Rather than IFs with static values, could you multiply the quantity by the hours then divide by 8 and round up?
-
Thanks for the reply. Not sure that works. If I'm following your process, if qty of 5 x 5 hours = 25/8 = 3.13 days. even rounding down that down gives me 3 days. 5 lights is a one day (5 hours installation). Got me thinking how else to sor this tho..
-
If 5 lights is a 5 hour installation then that is 5 units at 1 hour each and 8 hour days then that is
5x1 = 5/8 = 0.625 round up = 1
If you know the number of units and hours per unit - multiply those together - gives total hours
Then divide total by hours per day to get total days
Round up to get whole days.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 304 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!