Auto assign a name to a new created row (using a changeable list)
In short, new rows are add to a sheet using a form, these currently get manually picked by the team and they assigned them selves that job.
However, due to cherry picking I want the system to auto allocate that new row to a name.
As the team changes daily, I want the auto name to be chosen from the names of the people who are in work just that day.
My thoughts. Sheet 1 - Main data (Where the new rows are added using forms)
Sheet 2 a list of advisors which gets manually changed each morning and then this list is used by the formula to allocate work the (row) work out that day.
I would like this to be in sequence.
Chris, Jon, Bob and repeats. (on each new row added 1 persons name is assigned)
Help Article Resources
Check out the Formula Handbook template!