API & Developers

Archives for November 2019

CMMS Build up
Hello, Am working with a company as an IT which needs a CMMS tool for their mining clients for the WR, WO, PMs, AMs and so forth. And I need an expert of Smartsheet to help me on contract to develop the tool for them.
Navigate URL Automation
Hi Team, Is it possible to automatically navigate to a URL added in a cell if specific cell value changes to specific value? Please see below to understand the requirement. I have a tracker sheet for each project. Each tracker sheet having multiple task and once all task completed a formula cell shows to project completed…
remove column ids, row ids from Smartsheet json!
hi team, I need help with removing the overheard data from the Smartsheet api call that returns a json file, I need to remove all the overhead before putting the data into the pipelines, thanks.
Can a one to many relationship be created in Smartsheets?
For example I have sheet A that has my master list and all components within a "Kit". On sheet B I have multiple kits and would like to reference all the included components. I get that you can link cell to another just like and spreadsheet, but is there a way to link the value?
Update date field error
Hi. I'm trying to update a cell on a row which is a data field using the C# api. However, I'm getting an error {"Value is not supported for this column type. Use objectValue instead."} But when I'm trying to set objectvalue i get an error due to protection level I know I'm doing something wrong, but i dont know what :P
Custom Fields and JIRA Ticket Imports
My company is using a Smartsheet which uses custom columns fed by a request form. The purpose of this sheet is to process and track product enhancement requests, and occasionally we will migrate JIRA tickets into the process as well, which is what I'm setting up the connector to accomodate. The problem I am having is that…
Using Microsoft Flow to Send Email
Hello, Currently Smartsheet doesn't allow me to send an Alert with an attachment. The context of this is for a travel spreadsheet, when someone enters their itinerary, it will send the person an email with a standard email containing an attachment of various do's & don'ts. I think I've got my flow set up ok but I'm…
Row Id in email
Hi! I'm trying to generate custom PDFs with a specific template from a smartsheet row. The workflow currently uses an automation to send an email when the row is "done". Right now, that email contains the "Row Number" which is the only way to identify the row through the API (all the rest of the columns can be duplicate…
Webhook callbackUrl Port Support Query
Hi All, Raised two cases with Support but no response so starting new discussion. We have created smartsheet webhook with callback url having port 443, 8008,8000 and 8080 but able to get response when callback url configured with 443 (tried one by one port, doing PUT { "enabled": true } after creating webhook). Do other…

Trending in API & Developers

Smartsheet API Documentation unexpectedly asking for login (23 Apr)
I'm unable to log into the smart sheet API Documentation. Till yesterday I was able to access the API documentation did not prompt for login. Kindly help me log in to SmartSheet Official API and SDK Documentation Log in with Redocly
QR Codes/Bar Codes
Dear Smartsheet Community. Is there a means within Smartsheet to allocate a unique QR/Bar Code to a specific line in a grid, such that if you subsequently scan the code (outside of Smartsheet), the specific line/data record can be accessed? For now, I am thinking of an image of the relevant code added in a cell as an…
Moving many rows to another sheet?
My task is to move 3500+ rows to an archive sheet every two weeks. I'm using the python SDK Sheets.move_rows() command but am running into a timeout error (4002) after just 250 rows (granted there are a lot of columns). Can anyone recommend a better method than telling python to loop through the list, moving 250 at a time?…

API & Developers

Discussion List