-
Column webhook firing on all changes and repeatedly reporting same deleted row
I created a webhook with column scope as follows and enabled it. Everytime a change is made on the smartsheet, the webhook fires, even though I specified only one column for the subscope. Shouldn't it only change if a value in that column changes? { "message": "SUCCESS", "resultCode": 0, "result": { "id": 7548025422800772,…
-
New to API/python dvlpment- need help with directory path name
Hello, I'm looking to develop a use-case using the smartsheet-python sdk. Can anyone give me an example for this line and how it should appear in the code block to successfully pull a sheet as csv from smartsheet to a local/shared folder- download_directory_path This is from the Get Sheet as Excel / PDF / CSV section on…
-
SharePoint/Smartsheet Integration
I have a list of data that's maintained in a SharePoint Online site. On a weekly basis, the list info is downloaded and then uploaded into Smartsheet, where that information is used in several reports and Dashboards, Is there some additional functionality or extension capability where this process could be automated?…
-
What is the current version of Smartsheet?
Hello, I am currently trying to automate a process in which a Python script will reference a Smartsheet spreadsheet of a User Directory. I wanted to ensure there would be no compatibility issues with my version of Python and my Smartsheet API. I tried looking through all my preferences and plan settings and I could not…
-
Import Excel Data automatically
Hello Experts, We are currently exporting excel file from SAP to Desktop and the same file is being manually fed in smart sheets to accommodate the existing charts on daily basis to update. As of I don't find any plugin to correct SuccessFactors directly. Please suggest if there is any option in Smart sheet to…
-
Does Smartsheet retain any information from respondents that provide data in a form?
Does Smartsheet retain any information from respondents that provide data in a form? If so, what information is retained and what is the policy? I have been asked by my organization's leadership.
-
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…
-
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.…
-
API Demo: Creating a Formatted and Printable View of a Row
Here is a demonstration of a feature I created using SmartSheet's API. Let's say you want to print all or some content of a row. Or perhaps you want a nicely formatted and easy to read view of the row. The specific use case addressed here is to print a copy of a school library order for new materials. This print out will…
-
Is it possible to export a sheet as forms?
We often need to publish a report pulling data from a selection of columns, for a single row, sequentially on a page, and then the next row, etc (I.e. laid out like a document, not a spreadsheet). We currently use the Smartsheet add-on in google docs to do this, but it is frustrating and time consuming. Essentially what we…
