I have a column called "Cluster" in a list named "Cluster Assignment". The "Cluster" column/field is of type "choice", the choices are:
Cluster1 Cluster2 Cluster3
I have another column/field called "User" of type "people/group". When a new list item is added a particular user can be assigned to a particular cluster e.g.
Joe Blogs : Cluster 1 Tom Harris : Cluster2 Jill Main : Cluster3
Is it possible to have a workflow that detects changes in "Cluster" values so that no user have the same Cluster value, when Cluster values are changed/updated?
Currently if I change the Cluster value for Joe Blogs to "Cluster3" for example, the Cluster value for Jill Main stays as "Cluster3" and I therefore have to manually change the Cluster value for Jill Main to "Cluster1"
So I would like to know if it will be possible to use a workflow to automate the update process mentioned above....
Any assistance will be greatly appreciated.
Thanks in advance