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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!