Notification at multiples minus a number
Hello,
I have a spreadsheet where each row counts hours, then a column keeps a running total of all hours.
I would like to be notified at certain intervals as every 150 hours I need to do a task however I need some prep time so I would like to be notified 20 hours before 150.
So when my column value reaches 150, 300, 450, 600 I would like to be notified at 130, 280, 430, & 580.
While 130 is 15020, I cant track factors of 130 since then I'll get notified 260, 390, & 520.
Any suggestions? thank you!
Answers

Try a MOD function.
IF(MOD(SUM(Hours:Hours), 150) = 130, 1)
I am not sure of your exact setup, but MOD150 would only present the numbers 0  149. So whenever MOD150 equals 130, you are now 20 hours before the next multiple of 150.

Hi Paul,
That as very helpful, thank you!

Happy to help. 👍️
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.5K Get Help
 62 Global Discussions
 46 Industry Talk
 386 Announcements
 3.5K Ideas & Feature Requests
 54 Brandfolder
 125 Just for fun
 50 Community Job Board
 466 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!