-
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…
-
Add Grouping to Report Exports
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.
-
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: 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…
-
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…
-
Automation Help: Regarding Proofs
I want to record a date, when certain people approve a proof. When I set up a proof I am inviting several people, however, I need to record a date when a specific person (technically it could be 1 of 3 people) actually approves the proof. I have the {Proof Approved By} column (and as everyone approves their names appear in…
-
How do add columns in smartsheets dynamically based on a condition ?
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…
-
Allow for Multiple Lookup Values in DataMesh
-
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…