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?


  • Paul Newcome
    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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!