Hello
I am in charge of creating the schedule for my department. I have attached a template here.
as you can see I use initials and quite often probably just because of my incompetency I tend to forget to put someone down on the schedule.
How can I build a check or macro to ensure that I have accounted for everyone at work?
I intentionally left a few folks out in the attached template as I was trying different ways to see how to create a formula or macro that would alert me to their absence (for example I am missing "A" on Dec 1 and "M" on Dec 8th)
Logic is pretty simple - if you are not OFF or not ON CALL then you need to be covering one of the services. So A or M in this case needs to be assigned to a service on the respective days.
I am not looking for help with assignments. I am only looking to make sure that all my people are accounted for each day. All I need is a pass (all names accounted) or fail (someone missing- so I can take a second look and figure out who is missing). I
I seem to be terrible at making sure that all initials are covered for each day. I have even resorted to writing them down on a piece of paper and scratching off each name as I schedule them for each day.
thank you in advance
I will try to attach the screenshot here.
I am in charge of creating the schedule for my department. I have attached a template here.
as you can see I use initials and quite often probably just because of my incompetency I tend to forget to put someone down on the schedule.
How can I build a check or macro to ensure that I have accounted for everyone at work?
I intentionally left a few folks out in the attached template as I was trying different ways to see how to create a formula or macro that would alert me to their absence (for example I am missing "A" on Dec 1 and "M" on Dec 8th)
Logic is pretty simple - if you are not OFF or not ON CALL then you need to be covering one of the services. So A or M in this case needs to be assigned to a service on the respective days.
I am not looking for help with assignments. I am only looking to make sure that all my people are accounted for each day. All I need is a pass (all names accounted) or fail (someone missing- so I can take a second look and figure out who is missing). I
I seem to be terrible at making sure that all initials are covered for each day. I have even resorted to writing them down on a piece of paper and scratching off each name as I schedule them for each day.
thank you in advance
I will try to attach the screenshot here.