Sharing a sheet with a user with 2 different emails
I have shared a sheet with a list of people. They are all in my contacts. Now, they are transitioning to a new email. I added their new emails to my list of contacts but when I try to share the sheet with them, their contact with the new email does not appear at all. I tried changing the name in my contact list, so the name is different for both emails, but still the new emails do not appear. I am hoping to be able to share with both emails until the transition is complete. Any suggestions?