When exporting a Report to PDF or Excel from Smartsheet, grouping and summary rows should be included. As I utilize a lot of automated reporting, via PDF, this would create consistency in the report view and exported view.
Please reference support ticket/case 07281278 as well as community post at this URL: My Suggestion: It appears that when a sheet is copied (maybe when a new sheet is created in any way) via the API, there is some additional work that Smartsheet is doing on the back-end after the response to the create request is sent. It…
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…
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…
I have the date of implementation of the project and I need to dynamically add the columns based on the date. Like for example if I had a 1-2-2024 as my date. It must give ,me 12 months for that date like march 2024 to jan 2025 each column contains 1 month a total of 12 columns and adding to it I have so many projects some…
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…
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…
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.
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
