Weekly Volume Maximums

Hey all!
I am wanting to create an availability calendar for our call center. We can only accept about 200 calls/week. The goal is to auto-sum the daily volume column for a week period and to set a condition that notifies sheet viewers that we are unavailable to accept anymore calls that week if it is over the 200 call maximum.
Is there a way to do this?
Answers
-
To determine how many calls you have remaining, you could use a formula along the lines of
=200 - COUNTIFS([Date Column]:[Date Column], IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER(TODAY()))
This counts how many calls were made in the current week and subtracts it from 200. From there you could set up an automation that is triggered when this number reaches 0.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 207 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!