Dynamic View and Contact Lists
I have created a dynamic view of a clinical trial database for ~6 regulatory staff (with editor permissions) to update.
On occasion, they will need to update the Principal Investigator (PI) cell. This cell is set up as a Contact List that is NOT restricted to a list of values. When they access this field via their dynamic view - they can see the current PI, but they can't type in a new contact - nor do they see a list of contacts to select from.
When I try to do the same using their dynamic view - I (the sheet owner / licensed user) can see any and all contacts that are associated with our Institutional Smartsheet instance.
I would like for the Reg staff to be able to change the PI name from their view - rather than accessing the monster sheet it references.
ADDITIONALLY: I have edited all contacts that are associated with the referenced sheet individually such that their last names are first (ie. Smith, Tim) so that if anyone sorts this sheet by PI, they can more easily find who they are looking for. Could this be why they are not seeing anything?
Is there any way to Automatically change all contacts in a list to be viewed this way?
Thanks for any ideas.