I am trying to create an app which will allow me to allocate a User or Team (user maybe part of team) to a shift and I want to update Users profile with that shift.
Ideally I would select the Date/Time of the shift, then either select User or Team (which would auto populate Users of the team), then I could select multiple Users from drop-down and save.
Once saved, I would see multiple users (those I has selected) with the shift I had allocated.
Advice of setting this up would be much appreciated.
Sorry, each User and allocated shift would require its own row in google sheets, so not multiple User names in one cell.