Weekly Volume Maximums

Rebecca Davis

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?

Paul Newcome

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.