Prevent cells from changing once value is entered?
I have a multi-contact column that I'm using to fill in other cells. The problem is, if new names are added or removed it reorders the contact list. So when extracting the name to another column, the name of the person can change which column they are extracted into. Is there a workaround for this?
For example if I remove Lisa from the multi contact cell, the original tech 2 will now be tech 1 and so on for the rest.