Dear Community,
I thought I was clever to setup and create a List for my Team, where we can share and enter our Day-Off Time.
Therefore, I generated a Table with all the members and created for each month a separate Sheet, where within the sheet I have a second Table that is showing the days.
What I did not consider is, that with new members coming and some leaving, I am able to update the Table with the Agents but I have an issue with the data entered in the cells of the month.
As you can see in the below image on the left side, the current situation. In my Sheet with the Agents, I have 5 names with examples.
In the second sheet, I added the Month June and have the days accordingly. We did color the cells to announce, that we are not around. So in the below example, Edward won't be around
on June 5th.
Now a new Agent is added to the Table with Agents called Diane as seen on the right side in Row A7.
The nice thing is, that Diane is showing up also in the Month Sheet June but as you can see, the Cell F7
which I hoped would move to Cell F8 hasn't moved and therefore, the information now is no longer correct,
because Edward has no longer the day off, while Diane has. I also tried with numbers and it also does not work.
Is there some trick, how I can do that or build the Vacation form in a different way?
Thank you very much,
Mike
I thought I was clever to setup and create a List for my Team, where we can share and enter our Day-Off Time.
Therefore, I generated a Table with all the members and created for each month a separate Sheet, where within the sheet I have a second Table that is showing the days.
What I did not consider is, that with new members coming and some leaving, I am able to update the Table with the Agents but I have an issue with the data entered in the cells of the month.
As you can see in the below image on the left side, the current situation. In my Sheet with the Agents, I have 5 names with examples.
In the second sheet, I added the Month June and have the days accordingly. We did color the cells to announce, that we are not around. So in the below example, Edward won't be around
on June 5th.
Now a new Agent is added to the Table with Agents called Diane as seen on the right side in Row A7.
The nice thing is, that Diane is showing up also in the Month Sheet June but as you can see, the Cell F7
which I hoped would move to Cell F8 hasn't moved and therefore, the information now is no longer correct,
because Edward has no longer the day off, while Diane has. I also tried with numbers and it also does not work.
Is there some trick, how I can do that or build the Vacation form in a different way?
Thank you very much,
Mike
