I have a "Choice" column that uses a checkbox to add multiple items to a field in a list. The choices in the field are in the structure
Malcolm Reynolds - Customer Support Representative
Zoe Washburn - Human Resources
Simon Tam - Project Manager
I would like my workflow to add names to this field when tasks are assigned to them, and remove the names from the field when tasks are completed. Ideally, the field would also update the name field if a task is delegated from one user to another.
The field must be sortable (so Zoe can filter the list on her name and see items that still need her attention)
We must also be able to check the box to add names manually even if the person doesn't have a task assigned to them.
I suppose I'll want to query workflow status for that particular item, but I'm not sure how to go about doing it so that the field gets updated when a task is added or completed and is still able to be updated manually AND functions during delegation.