How can you edit a collborators e-mail address?

Norman Harris
edited 12/09/19 in Smartsheet Basics

I want to edit an e-mail associated with a collaborator because it has changed.  There seems to be no way to edit anything in the Sharing area.  I know how to edit My Smartsheet Contacts, but that doesn't help.  Sometimes the collaborator contact doesn't show up in My Smartsheet Contacts.  Even if it does, and I successfully Edit it, the email already assigned to the collaborator isn't updated.  If I delete a collaborator and try to add him/her again with the new e-mail address, the old address is still readded.  Using Find & Replace doesn't find collaborator e-mail addresses.  

Anyone have a workaround?

Comments

  • Hi Norman,

    When you type a person's name in a contact list cell or sharing/email field in Smartsheet, the email addresses that are auto-suggested come from multiple locations:

    1. Your Smartsheet Contacts—delete that contact and add a new contact with the new email address.

    2. The Sharing tab in the sheet—make sure that your collaborator has added that new email address to their Smartsheet account and are using it as their primary email address. They can do that with the steps here: https://help.smartsheet.com/articles/2392037-change-the-email-address-used-with-your-smartsheet-account 

    If they created a different Smartsheet account with the new email address, then you'll want to unshare sheets from the old email address, and share them to the new email address instead.

    3. If you're typing in a contact list cell and the old email address is in other cells on the sheet. You'll have to manually remove the old email from those cells. The easiest way to do this is to apply a filter on them in the Contacts list column, add the new contact to the topmost cell, then drag that down to all the other cells.

    To completely prevent that old email from being auto-suggested, you'll need to remove it from all three locations.

    If you run into issues while doing this, reach out to our Support team and we can help walk you through the steps above.

  • Hi Norman,

    When you type a person's name in a contact list cell or sharing/email field in Smartsheet, the email addresses that are auto-suggested come from multiple locations:

    1. Your Smartsheet Contacts—delete that contact and add a new contact with the new email address.

    2. The Sharing tab in the sheet—make sure that your collaborator has added that new email address to their Smartsheet account and are using it as their primary email address. They can do that with the steps here: https://help.smartsheet.com/articles/2392037-change-the-email-address-used-with-your-smartsheet-account 

    If they created a different Smartsheet account with the new email address, then you'll want to unshare sheets from the old email address, and share them to the new email address instead.

    3. If you're typing in a contact list cell and the old email address is in other cells on the sheet. You'll have to manually remove the old email from those cells. The easiest way to do this is to apply a filter on them in the Contacts list column, add the new contact to the topmost cell, then drag that down to all the other cells.

    To completely prevent that old email from being auto-suggested, you'll need to remove it from all three locations.

    If you run into issues while doing this, reach out to our Support team and we can help walk you through the steps above.