-
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)?
-
Dual Horizontal Split Column Option
I know this probably isn't possible but I'll ask anyway. :) Is it possible to create a horizontal split on a sheet where the "top" split would have different sets of columns than the "bottom" split? It would be like having two primary rows on a single sheet. This would be like having two sheets in one for more complete…
-
How do I dynamically update a dropdown list?
I want to create a multi-select dropdown list with all future dates and this will be sent out in a form. Currently, smartsheet only offers a date selector with one max date. I was wondering, is there a way to upload values into a dropdown through an API? Otherwise, can I upload values into a dropdown from another sheet?…
-
How do I get all the rows in a Smartsheet by sending an API call using the requests package in pytho
I am trying to get just the rows (list of rows) in a smartsheet in a single API call by using the Python requests package instead of the smartsheet SDK. I tried to use /rows in my request like so: r = requests.get("https://api.smartsheet.com/2.0/sheets/{sheetID}/rows", headers=smartHeaders, params=payload) but…
-
Create/Update/Delete APIs for Sight Widgets
I don't see any Create/Update/Delete APIs for Sight Widgets (Read is handled via getting a sight given it's id). In the docs, the sight update command can only be used to rename the site. I've tried to pass in the complete JSON for the sight along with it's updated widgets... but get a { "errorCode" : 1008, "message" :…
-
Drag & Drop Emails from Outlook to Smartsheet in Chrome & Email is Deleted from Outlook
When dragging the email from my Outlook window to Smartsheet in Google Chrome it removes the file from my Outlook entirely and the email is gone. I tested this in MS Edge and confirmed it does not happen when using Edge; the file copies and uploads to Smartsheet without deleting it from Outlook. * Windows 10 Pro for…