DataTable doesn't update sheet row after unique identifier changes


Hello, I have a sheet with a connection to a DataTable. The unique identifier is email addresses, sometimes I have to update the email in the sheet as it's changed. After I change it, the row's cells are not updated with data from the DataTable. I've confirmed that the DT does have the updated email and it's data points but it's still not sharing the info to the sheet.

Is there a reason why this could be happening?



  • Genevieve P.

    Hi @Ryan P Anderson

    If I'm understanding you correctly, you've updated both the DataTable and the matching value in the sheet, but the corresponding columns/data aren't being synced in your sheet moving forward.

    Is there any possibility that the email is spelled slightly differently in both places? Does the connection sync when you manually refresh it?

    If the sheet is still not updating even though Data Table has the correct information, I would recommend reaching out to Smartsheet Support with the sheet URL and a video recording.



    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

  • marc4
    marc4 ✭✭✭✭

    Have you checked the datatable to make sure the record with the previous email address is gone?