-
CORS interruption while fetching Smartsheet API
We want to use simple fetch to GET request the data from our Smartsheet instead to the Smartsheet JS SDK. The code snippet is as follows : This JS file has been linked to a HTML file which is being fired up on the browser using Live Server extension available in VsCode. But upon checking the console on the browser (all…
-
Merged: Make the Undo Button Active
This discussion has been merged.
-
Using WebHooks & API to create your own custom Column Functions
I thought it might be useful to share a general method I developed to add Functions missing from Smartsheet. This technique makes use of WebHooks & the API. Most important: users can add this to their sheets nearly as easily as they can add formulas. They do NOT need my help as a programmer For example here are a couple…
-
Row Grouping with API
Is it possible to achieve Row Grouping using the api? I would like it to look like this However, when trying to upload the data with my python script it looks like this Thank you!!
-
Is there a way to the send the pdf attached to a row out as an email attachment?
Hi, I am using document generator to generate a pdf from a row in my Smartsheet. I want to then be able to send this pdf as an email attachment automatically. Is there a way to do this? Do I need to use API? Thank you!
-
How to divide single request with multiple contacts to individual requests.
Does anyone know how to take a single line, with a single multi-select cell, and have that line parse/delineate/divide in to individual lines, either through a formula or an automation? Scenario: we are receiving schedule block request for team, and multiple people may be on the block request, therefore we have multiple…
-
How do I determine the Root Domain for a Smartsheet Installation?
I have a customer who has several domains added to their Smartsheet installation, and I'm trying to determine how to idntify the original root domain, or the domain that was used when Smartsheet was originally implemented for the customer. Is there a way to identify the root domain? Thanks.
-
Adding Sheet to Report using API
After some trouble with this command line string. I am getting a 1006 error even though I am the Owner of the Report and Owner of the Sheet that I am trying to insert. I can do this manually without any issues. Any thoughts? curl -H "Authorization: Bearer TOKENHERE" -H "Content-Type: application/json" -X POST…
-
Multiselect Drop Down (Columns) and Export (Excel) or API
We have several multiselect drop down columns in our sheets that get either exported to Excel or get sent to other systems via an API; when it exports or the other "systems" receive the data that field / cell (which has multiple items) will not separate the items by anything (not a comma, colon, space, etc.). WHY? The…
-
Remove/Delete existing hyperlink using API
Per the problem outlined in the below community post, it appears the API is unable to remove existing hyperlinks from cells. It is possible to add or update hyperlinks, but not delete/remove them. Please add the ability to either completely clear cells (including hyperlinks) or remove just existing hyperlinks using the…