I am wanting to do a conceptually easy thing.
It is easy to have all calendar entries for all users in the same sheet.
A slice can be used to limit users to seeing only their own entries.
It should be easy to enable the admin or specific user to see all entries at once.
What I would like to do is have a form or dashboard view where the admin can select a dynamic slice.
Showing one user at a time would be fine. I am imagining that it should also be possible to use an enum list to show one or more.
How would I do this in an easy efficient way ?