API & Developers

Archives for August 2019

Python Script For Refresh Sheet
Hello Smartsheet Community, I need to write a script in Python to refresh a sheet. In my sheet I am using the Today function to calculate the total net days from one specific date. I take that data and use it as a widget on my dashboard. Problem is, the widget doesn't update unless the I physically open the sheet. Is there…
Integration with ServiceNow, the ITSM tool
We use Servicenow for technical incident management. Some incidents evolve into work packages for specific tech teams. These teams use SmartSheet for task management. So migrating an incident in ServiceNow to an action item in SmartSheet would be handy. Anyone done that?
Test case Smartsheets
We're going into UAT soon. I've chosen Smartsheets to put all the test cases the testers need to run. Some things I'm wondering about - hopefully all of you ppl smarter then me can help: 1. I imagine that I will need multiple sheets right? Each tester will run the same end-to-end set of tests and record pass/fail/defects.…
smartsheet dashboard is not auto updating
Hi Team, Im leveraging the API to publish data to a smartsheet. Then i have a smart dashboard set up to graph that data. But when i push new data to the sheet, the dashboard charts don’t auto-update.[It says the source is modified but it’s not ...it is the same] I need this to be automatic, so when someone goes to the…
Can Smartsheet get data from custom HTML forms on a website?
Hello, If I'm building a website, can I create a custom HTML form and get the data into Smartsheet somehow? Smartsheet's native forms don't have the capabilities that I need (conditional logic) and I would like to make my forms a bit prettier. Thanks in advance!
How to un-hide all columns in a smartsheet using smartsheet C# SDK?
How to un-hide all columns in a smartsheet using smartsheet C# SDK?
Is there any way to delete a column with conditional formatting in smartsheet using smartsheet C# SD
Is there any way to delete a column with conditional formatting in smartsheet using smartsheet C# SDK?
How to delete a column with conditional formatting rule using smartsheet C# SDK?
How to delete a column with conditional formatting rule using smartsheet C# SDK? We are getting error - "The column specified is used in a conditional formatting rule, so the column cannot be deleted and its type cannot be changed.".
Delete all conditional formatting in a smartsheet using smartsheet C# SDK
How we can delete all conditional formatting in a smartsheet using smartsheet C# SDK?
using external data in a form and sheet and for validation
Our company has an internal application. I would like to reference this application's data in a form and in a sheet: * When a user is submitting a form, it lets them select a value from a drop down that is populated from data in this external application * When a user is submitting a form, it lets them enter free-form text…

Trending in API & Developers

Reseting a row parentId
Hi, For some needs, i would like to reset the parentId value of a given row. what value should i be using to force the parentId to be reset ? I tried :0; null; "0"; "null" and none of them made any positive result :
How to update picklist column
Hi, Currently I have a few columns which contain individual list items, but when I send an update through the API they appear as a single string Is there a specific way I need to be sending list items so that each item appears individually?
Creating Webhook with subscope
Hi, I am trying to create a webhook via payload with the request body like the one below, which is an example from the API document, it failed and returned a HTTP status code 400. { "callbackUrl": "https://www.myApp.com/webhooks", "enabled": true, "events": [ "*.*" ], "name": "Webhook for Sheet Creation", "version": 1,…

API & Developers

Discussion List