-
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 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…
-
Unwanted Default gray background of the dropdown selections
Hello, I am trying to change the backgound color of the Dropdown selections that appear in the cells to white. Is this possible? is there any CSS formatting i can give to the background of the dropdown selections? I would like that gray background gone please
-
Meeting Minute Tracking
Know how to track the previous meeting minutes without having to expand all parent and child rows so you can copy it on the next available line and enter or remove information for the next meetings. Have an option to generate a pdf that can be logged on a separate sheet for review of the meetings that you have throughout…
-
Discrepancy in API document and response for Sheet Object
I noticed in the Sheet Object API document, https://smartsheet.redoc.ly/tag/sheetsObjects#section/Sheet-Object, the field is "proofs" object, while in the API response for the same for "Get Sheet" API, the field is a "proof" object. There is a difference in singular and plurality, Is this a discrepancy? Can you please help…
-
Smartsheet URL and Redirect URL for connection with Celonis
Hello together, i am trying to connect Smartsheet with Celonis. I already have a Client ID and Client Secret but everytime I try to connect both, Smartsheets shows an error saying Redirect URI ist missing or wrong. Does anyone know what to fill out in the Developer Settings of Smartsheets in the field APP URL & APP…
-
Solution for Table Join-Like Behavior
I'm looking for some ideas... Being that Smartsheet is a project management software, I imagine there is at least one person doing something like this! Some Background For apartment complex renovation projects, we have a list of tasks that are repeated across many apartment units. Inside of that task list, there are also…
-
smartsheet api: how to read a certain cells value from google apps script
Hi all, could someone please help me how to read a certain cells value from google apps script? I have token, sheet id, col id and row id, but do not know how to do the code. Thank you, Joachim