Hello,
I am trying to create a weekly calendar from a data validation list which will populate cells with users based on the selection.
I have a list of 15 users with different names, and I want it to be able to populate in order and be able to "wrap around" to the next week selection.
<tbody>
</tbody>
I have more time slots than this but that should be non issue to add once I get this figured out. I wanted to know if there was a way via formula to determine the next user in line from the list based on the previous entry.
I am trying to create a weekly calendar from a data validation list which will populate cells with users based on the selection.
I have a list of 15 users with different names, and I want it to be able to populate in order and be able to "wrap around" to the next week selection.
Monday ## | Tuesday ## | Wednesday ## | Thursday ## | Friday ## | |
Time Slot | worklane | worklane | worklane | worklane | worklane |
9:30 | Tom | ||||
10:30 | Larry | ||||
11:30 | Joe | ||||
<tbody>
</tbody>
I have more time slots than this but that should be non issue to add once I get this figured out. I wanted to know if there was a way via formula to determine the next user in line from the list based on the previous entry.