DataTable connection error: "User error: Sheet not found"

Jake Taylor

I have a sheet that connects to a Data Table and has worked without any problems for a long time (6+ months of daily refreshing). All of a sudden I see this error. I open the sheet (which has not been deleted or moved) and I see the error in the attached screenshot in the DT connection. Which sheet is being referred to that can't be found? Clearly the sheet exists. Anyone have any ideas?

David011

Hi Jake,

Based on the screenshot, the error message "Sheet not found" suggests that the DataTable connection is unable to locate the sheet it was previously linked to. Here are a few potential reasons and solutions:

1. Sheet Renaming or Moving: Even if the sheet exists, it might have been renamed or moved to a different location. Double-check the sheet name and its location to ensure it matches the connection settings.
2. Permissions Issues: Ensure that you have the necessary permissions to access the sheet. Sometimes, changes in user permissions can cause connectivity issues.
3. Connection Settings: Verify the connection settings in the DataTable. Ensure that the correct sheet is selected and that all fields are properly mapped.
4. DataTable Configuration: There might be an issue with the DataTable configuration itself. Try refreshing the connection or reconfiguring it to see if that resolves the issue
5. Smartsheet Support: If none of the above solutions work, consider reaching out to Smartsheet Support for further assistance. They can provide more detailed troubleshooting steps

Jake Taylor

https://community.smartsheet.com/discussion/comment/482608#Comment_482608

Thanks for the quick response David011. I don't think the sheet was renamed, moved, or permissions were modified, but I'll look into that.