-
Updating rows with multi_contact cell?
Hello, I'm using the Python API to update some rows as follows: copy cell values in specific columns from an old row, and append these to an update request as cells in the respective column for a new row. This works for all but a contact column (with multi_contact enabled). I'm getting the error that I need to use…
-
API Access to Column Formulas
I have been trying to understand how to handle column formulas and all I can see is that you have error messages to let us know that we can modify cells in columns with column formulas but there is no column attribute to indicate that a column formula is present via the API. Also, when a column formula is present, it is…
-
API Load Error with Python Executable
I have created a python script in PyCharm, the file has been running with no issues. I converted the file to .exe using PyInstaller and auto-py-to-exe but with both methods I receive the following error after running the .exe: "Import Error! Could not load api or model class folders." A screen shot of the command line is…
-
Rolling up multiple projects onto a dashboard
Is there a way to roll up the critical pathways and key milestones for multiple projects / smartsheets into one dashboard?
-
Can we plot address info from Smartsheet live on to google maps?
Looking to create a live map (Ideally google maps) that updates with Smartsheet address info (Postcodes)
-
HYPERLINK API
We have been using HYPERLINK("http://website.ws/links", "Click Here") in both excel and google spreadsheet, and since we need jotforms integration for client our current links in smartsheet is very long and creating hyperlink manually for each row is a terrible ordeal. It would be great if you add HYPERLINK("URL", "Text")…
-
Save button is not enabled after new row is added in Smartsheet via Bridge
There is a new row added in the Smartsheet via Bridge after adding a row in another sheet. Though a new row is added successfully, the Save button is not enabled to trigger the "Row Added" event in Webhooks. Please let me know how can i receive the "Row Added" trigger once the row is added, So i can create new work item in…
-
CORS Support for smarsheet API Access
Hi Folks, I am trying to invoke SmartSheet API from one of my web based application hosted on corporate domain inside javascript container using standard and XMLHttpRequest methods. How ever i am getting an issue when accessing api.smartsheet.com over HTTP Post where its not allowed because the Allow-Access-Control-Origin…
-
Archiving Design Pattern in Smartsheet
Hello, We currently have a very large Smartsheet we use to collaborate with external business partners. I have created workflows to add rows each week, and our cross-functional teams complete tasks related to each of these rows over a period of weeks. We are struggling to find the best way to declutter this sheet once all…
-
How to create a time gauge or something similar?
Hello, I am trying to create a widget to display on a dashboard. This widget will give the viewer an immediate idea of where the project is in the project timeline. Ideally, the widget would look like the time gauge image attached. There would be 4 segments instead of 3. The needle depicts where the current date falls on…