Tracking Request Hours and Placing Requests into a bucket based on # of hours used
First, I appreciate all the help and suggestions, since I'm struggling with how to accomplish this task.
I have a sheet that contains requests,(assigned a unique number) as requests are approved the # of hours is captured for each request.
Each billable bucket is capped at 1800 hours and requests can spill over from one bucket to another (i.e. request 1 is 2200 hours, would fill bucket 1 and 400 hours would go into bucket 2)
Here is what I'm trying to do:
- When a request is approved know what bucket it is going to be billed in based on the hours remaining in the current bucket. Would ideally update the original request sheet.
- Maintain a log of all billable buckets and show the request number associated with that bucket and the number of hours used. If a request fills a bucket the remaining hours go into the next bucket.
- Be able to show the current bucket and the number of hours remaining in that bucket.
I'm open to adding any additional sheets as needed, including add helper columns to my original sheet.
Frank Smith, PMP
Assistant Director | IT Special Projects Mgr.
Oregon Parks & Recreation Department
If my response helps, please mark it as an accepted answer. 😎
Answers
-
Hi Frank,
Do you really need to move his into buckets or can you just divide the total by 1800 and know how many buckets are full and how much is in the next bucket? E.g. if you've used 4,900 hours you've filled 2.72 buckets - 2 buckets are full and you have 1,296 hrs in the 3rd.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!