Forum Discussion
Auto populate available shifts according to rank
Please see how far my enclosed solution corresponds to your ideas.
You can then donate the money to a charitable institution.
Hi officerdon,
I created a second worksheet using the Snake variant. It was not so easy to solve with Knoff-Hoff, so I had to create an auxiliary column old-scool. Please do not delete the AM column. I have hidden it so that it does not interfere.
I hope it corresponds to your ideas.
Thank you also in the name of St. Jude. I hope it will do some good.
Good morning. I started working on the OT list. Once I clear out the initial shifts on the left and put the new requests in, the formula stops working in the "snake" book. In the "chief gets all", it shows "#NAME" as well. What am I doing wrong? I believe I initially replied to my post. Sorry if you get a double reply!
- Works flawlessly!!! Thank you so much. Got next months OT schedule done in record time! Your time is greatly appreciated!!
Hiofficerdon,
I have made a second version without modern functions like FILTER() and XMATCH(). Please try the two new spreadsheets (old scool) and see if it works for you.