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…
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…
I am trying to build an automation that updates an excel file to smartsheet once I run it. I have build that program but issue i am facing is that they are getting updated below the previous one. So I want to delete the rows first .Is there any way to do it without requiring row id.?
Hi. I have been able to stumble my way to successfully add new rows to my Smartsheet with the POST API request. However, I can't figure out the correct format to send more than one row at a time. I see reference to Bulk Operations in the documentation but I can't find any examples of exactly what that looks like. Would…
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.
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…
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,…
Has anyone had success adding Group Members via API (not being a system admin but having Group Management permissions)?
Please make the undo button active. Or at the very least, make it possible to restore your sheet to a previous version.
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…
