Stop Accrual Formula
Hello,
I need help creating a formula to stop the accrual process once a number of hours has been reached and then to begin the process again after hours have been used. My Columns are below
so once the balance is 240 then stop hours earned
and then once the balance is below 3.08hrs of 240 then resume accruing not sure if it's possible but will appreciate any and all help
Answers
-
I may have a solution for you though it may not be exactly what you are looking for.
2022 PTO Hours Earned (Converted to Column Formula): =IF(Balance@row + 3.08 < 240, 3.08, (240 - Balance@row))
2022 PTO Hours Used: Just a regular row - No Formula
Balance (Starting on the second row): =Balance1 + [2022 PTO Hours Earned]1 - [2022 PTO Hours Used]@row
I put the first balance amount as something that you would need to enter in manually. I also added a bit extra in the formula in case you wanted the person to earn up to the amount they could get without going over.
Hope this helps.
Heath Hilton
Hope this helps!
Heath Hilton
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 202 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!