I have a sheet where the "Assigned Technician" contact list field will populate the user's email address instead of their name. I have edited the contact to include the name, I have re-added the user to the contact list by using "+Add New" in the edit contact field, and I have updated my personal contact list under settings.
This has happened for only two users so far, I think I was able to fix one by the "+Add New" technique, but the second still saves as email address initially, it will save with the name only after editing it.
How can I fix this to ensure the name always appears?