Click a button and have hours spread across depts
I am trying to figure out how to automate taking one number and spreading it across a number of different cells. I have created a sheet where I track my time and allocate it out across the depts I support. There are over 15 depts and 8 of those are very common to spread time out to as I run projects for them specifically. My vision is that in the Hours column, I would put in say, 5 hours, then click a checkbox in the call center column and then it will calculate the number of hours divided by the number of call centers (in this case 8 call centers divided by 5 hours) and put that answer in the cells under their depts. Here is a simple screenshot:
I made this example even more simple where I need to spread out my 5 hours over 5 depts so after clicking the box under CCs, 1h will appear in each of those depts.
I feel that there is some way to do this but not sure how!
Help Article Resources
Check out the Formula Handbook template!