-
Report information is not displaying on dashboard all of a sudden
I have built a dashboard that houses a number of reports, displaying where production is at which stages and the number of items being built. It recently stopped populating the report data and appear on the dashboard. When I click on the reports it brings me to them and the data is there and operational. I have attached…
-
Smartsheet form + website data connection
Hello, I'm exploring the possibility of connecting a Smartsheet form to our website's content management system. Specifically, I'm interested in implementing the following workflow: A user accesses a Smartsheet form to propose updates to specific website content (e.g., a location description). The user enters the new…
-
Fix misleading error when using API to get a sheet that is still in the process of creation
Please reference support ticket/case 07281278 as well as community post at this URL: https://community.smartsheet.com/discussion/130648/when-the-copysheet-api-responds-is-the-copied-sheet-really-fully-created My Suggestion: It appears that when a sheet is copied (maybe when a new sheet is created in any way) via the API,…
-
When the CopySheet API responds, is the copied sheet really fully created?
I am synchronously using the CopySheet API to make a copy of a sheet. This API responds with a sheet summary, which itself includes the copied sheet's id. Immediately when that sheet is copied, I call the GetSheet API to get the full details of the new sheet. Mostly this works, but a moderate number of times, I will get a…
-
Best way to automatically copy a Smartsheet file to a SharePoint List?
I've been looking on the internet for a good way to copy a Smartsheet to a SharePoint list. One of the recommendations was to user Datashuttle which I tried but it only creates a .csv or .xlsx file in the SharePoint library. What I need is for the SharePoint List to be updated automatically from the Smartsheet file so the…
-
How can I obtain the URL for a form that is attached to a sheet ?
I need to obtain the FORM URL that is associated with a sheet that is copied via API so that I can populate the URL in a cell. I was reading over the API documentation and cannot seem to find where this is possible. I know this has been asked sporadically and apologies for the duplicate asks, but this seems like such a key…
-
Obtain Form URL from Workflow / API
When working with multiple sheets and creating solutions, there are often times when the URL for the form is needed. Currently the only way to obtain this URL is a manual process. I would be extremely beneficial to be able to call that form URL via workflow and have it populated in a particular cell or be able to be…
-
Get a sheet URL with the Sheet ID [API]
I'm using Python and I want to get the URL of a sheet if I know its sheet ID. I try to create a list of hyperlink thru the API. I already have access to the sheet and I could copy the url by hand, but that is not the point.
-
Smartsheet API - Is it possible to create a copy of a sheet and maintain the row and column IDs?
Is it possible to use the Smartsheet API to create a new sheet from a copy of an existing sheet, but maintain the row and column IDs? Ideally the output would be 2 sheets with unique IDs, but the row and columns within each would have identical IDs
-
Logging and tracking cross-sheet functionalities
Hello! My organization uses cross-sheet functionalities (formulas, workflows and API) pretty intensively. So much that when we are working through ideas to embed new processes, it can be a bit cumbersome to understand what is already at play. Essentially, we do not have any type of log or systems map to reference where or…