-
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…
-
Smartsheet Webhook callback
Hi, When the smartsheet event callback is send to the url (server) it expects to receive a call back acknowledgment (status 200). If the subscriber fails to respond with a 200 status, depending on the response, Smartsheet may retry delivery up to 14 times. My question is how much time do we have to send back the call back…
-
Smartsheet API response is incomplete.
I am using this API - https://api.smartsheet.com/2.0/sheets/{SHEETid}?rowsModifiedSince=2023-01-15T00:00:00.000 , this is not returning all the rows that are modified since the given time. From the UI , I can apply the same filter and get desired rows.
-
How to use advanced formulas to pull information from two sheets into new (third) sheet
Hello everyone! I am hoping to get some tips/advice on using Index Match/Collect (I think is the right route). Currently, my company has one of our data sources tracked and managed through smartsheet. My goal is to make a new sheet, that is populated from pulling the data from our primary data source BUT I want to filter…
-
QuickBooks Desktop and Smartsheet - Possible API Integration?
I have a client that is switching from customized software for Construction Project Management to Smartsheet and is hoping to preserve his ability to have a back-and-forth (or one-way) integration with QuickBooks Desktop. The previous software was using Intuit's QuickBooks Web Connector to integrate the two applications,…
-
Add Group Members via API
Has anyone had success adding Group Members via API (not being a system admin but having Group Management permissions)?