-
Creating rows as children using the API
I've successfully created a Python script to update a sheet in Smartsheets based off a table in postgres. The postgres table updates every hour, so I have the code running every hour after the update. It works great. I have the code set up to create my dataframe, delete all the rows in the sheet, then append all the new…
-
What causes a column ID to change?
Hello, What can cause a column ID to change? We have an integration from one of our software applications to a sheet, and we are having issues because the column ID will change without us knowing. Also, is there a way to see the column ID without having to use the API? For example, through a portal? We opened a ticket for…
-
Web Push Notifications to Windows 10 Notification Center
We have been relying on email to notify people of any Smartsheet notifications they may be receiving as our users are not in the application daily. The problem with the emails is that our company will not add anything to external to our safe sender's domain, so anything from Smartsheet comes along with a huge red banner…
-
Trigger Data Shuttle to run with the API
Can't schedule a data shuttle monthly, so maybe if we could trigger a workflow run via the API that would solve that problem.
-
Can Dynamic Views be manipulated via the API?
Our business is considering adding Dynamic Views, but we would want to set them up/manage them programmatically. Is this possible?
-
Developer Tools
Hello Could you activate developer tools for my account? I need to add an app to work with API using OAauth. I have posted a case #05974342 but it is still without an answer. Thanks, Michael
-
Call APIs from a formula
Alternate title: Make the most requested calls to an (ideally every) API available as formulas. Often in the community, someone will ask how to do something in a formula. Often, the response is, "You can do that in the API.", or "Just use the API". Here is one of many examples: "How do I look up last week's value of a…
-
Software solution using Smartsheet
Hello, My experience thus far with Smartsheet has been as a Systems Administrator for the last four years. Prior to my even learning Smartsheet, I had this idea for an app that would help to streamline a very specific business practice within the higher education industry. The thinking was that I needed to have someone…
-
API Conditional Formatting
Hi - It sure would be nice to have the ability to update conditional formatting via the API. I see a thread from 2016 - is this something that the dev team could look at? Many Thanks, Sean
-
Use data from one grid to fill master grid
Please consider this scenario: I'd like to update the data available in Grid 1 to a grid called Grid M. Considering that Grid M might have previous values, I'd like to overwrite them with Grid 1's data. I prefer overwriting instead of adding or copying rows because I want to use this Grid M as a master file that copies…