DataTable doesn't update sheet row after unique identifier changes

Ryan P Anderson

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.

Cheers,

Genevieve

marc4

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