Everything else
Start from what you are seeing rather than from what you think is broken. Each page below names the symptom, explains why it happens, and says what to do about it.
Several of these are the product working as designed, which is worth knowing before anybody raises a ticket.
#At a glance
Symptom | Usually because |
|---|---|
Macro says "Finish setting up this sheet" | The stored link points at the sheet itself (app.smartsheet.com/sheets/…) rather than a publish link. Usually because it was pasted straight from the Smartsheet address bar. Sheet links canno |
Macro says "This link can't be embedded" | The URL is not a Smartsheet publish surface. Only https links to publish.smartsheet.com, publish.smartsheet.eu, or app.smartsheet.com/.eu on the /b/publish path are allowed, and this is enfo |
Macro says "Smartsheet not configured" | No URL and no sheet has been saved on the macro. |
Readers see a Connect panel instead of the interactive table | Viewer access was never set up, so the table can only be served to readers who have their own connected Smartsheet. And anonymous visitors cannot connect at all. |
Interactive tables that used to work stopped showing data | Either the author disconnected their Smartsheet account (which drops the sheet bindings they own), or the macro was copied to another page and the signature no longer matches. |
After picking a different sheet the macro shows nothing | Choosing a new sheet deliberately clears the old publish link and signature, because they describe the old sheet. |
Apply is greyed out | Either you are not logged in to Smartsheet, or the view you selected is already the one stored (the button reads "Applied"). |
Sharing panel says "Log in to Smartsheet to see or change how this sheet is shared" | Sharing state and publish links are only readable through a connected Smartsheet account. |
There is no "How readers see the sheet" section at all — only Width and Height | The macro was set up by pasting a publish link, so no sheet is selected. Sharing options are only offered for a sheet chosen through a connection. |
Sharing panel or Apply is unavailable even though you are connected | Publishing, removing links, viewer access and signature minting all require Confluence edit permission on the page, because the panel shows live publish links. |
"We could not find this sheet in your Smartsheet account." | The pasted sheet link was not found in the first 1,000 sheets scanned, or it belongs to a different Smartsheet account than the one connected. |
Search in the sheet picker seems to do nothing | Server-side search needs at least two characters; below that it just pages through the plain list. |
"Used on N pages" counts look too low | The scan covers only the first 250 pages of the space and at most 1,000 macro instances. The page states this under the tab. |
Interactive table is slow, times out, or never loads | The whole sheet is fetched in one request and filtered in the browser; there is no paging. |
#In this section
#Related
Most of these are expected behaviour.
