Forum Discussion
Schedule Date/Time & Person validation
Hi all I am putting together a schedule for super user support for our EPR go live in September and I want to alert users to assigning the same super user to the same shift on the same date as se...
Hi Quadruple_Pawn Thank you for this, however I want to allow multiple instances of 'Role Supporting' for the same shift but prevent a name appearing twice with the same Date/Shift combination. And so, I can have Shift /Date combination of 8/9/2022 Shift 08:00-16:00 with Doctor -Mark Williams & Doctor Fred Bassett but I cannot have Shift /Date combination of 8/9/2022 Shift 08:00-16:00 with Doctor Mark Williams & Doctor Mark Williams plus I want this to apply all other shift members
Unfortunately i didn't understand what you want to do when i posted my first reply in this discussion. My suggestion is to apply conditional formatting for the instances in which duplicate entries for "Role supporting" , "Shift" and Doctor/Staff Nurse/HCA are found. You can try this for example by selecting "Doctor4" in cells D2 and D3.
- Thanks very much. I will give this a go!