-
Smartsheet API and pyinstaller ImportError
I have a python script that takes a csv file and adds the rows into Smartsheet. When I run my code through the command line the script runs perfectly. However, when I created an application using pyinstaller for this script, I am getting an Import Error! Could not load api or model class Sheets Is there a solution to this?
-
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…
-
A way to place the Row ID (for APIs) into a cell value with formula?
For clarification, the ID I am after here is the Row ID you can view in the properties of a row. I'd like to be able to do something like have someone export a sheet and send it to me for processing, and have a pointer directly back to which records there might need a resulting update, to be done via automation, that would…
-
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…
-
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
