-
Issue with Syncing Smartsheets to Outlook
How do I format the time columns/add proper formulas to get the calendar to sync to outlook with the times included? Right now showing as all day event (see right calendar)
-
Quotes within a formula for API PUT/POST
How is the data supposed to be formatted when a formula has quotes within it such as =IF(X=1,"One,"") ? I am getting just slashes in place of the quotes when I export a formula using the API, but when I use the same syntax to add/update a column with a formula it doesn't parse correctly. I tried /" and double-quotes.…
-
SmartSheetAPI PUT
Hello, I want to use the Smartsheet API to update the content of a cell. I have set the API key in the header and tried the following using Postman: PUT Request URL: https://api.smartsheet.com/2.0/sheets/{sheetId}/rows/{rowId}/cells/{columnId} Request Body (JSON): { "value": "test", "displayValue": "test" } However, I'm…
-
Python SDK API to add rows with Multi Columns to Smartsheet
I have a script that reads columns from my source Smartsheet (SS) and gets the values from the columns in the SS and stores them in variables. This code works. Where I am getting stuck is assigning the variables (2 or more columns) to a new row and then adding the row to the destination SS. For example: Source SS, reads…
-
How to programmatically erase a date column cell, with project settings and dependencies enabled?
Hi everyone! Need your help! I'm currently facing a challenge while attempting to programmatically erase a date column cell, with project settings and dependencies enabled. I am able to change the date, but not able to erase the existing date. I can successfully delete the column value manually, but I'm not able to achieve…
-
Using Smartsheet as chat hub
Hi community. I am developing an app through SS API and am looking to connect chat channels like WhatsApp, Facebook, SMS, etc to Smartsheet. Each row represents a customer and ideally, we want all chats with this customer from all popular apps to populate into the conversation section of SS. Is this possible? If not, we…
-
Sample cURL throwing errors
Hello All, I am looking to use cURL for some basic API updates to my sheets. I have used it successfully to pull down data for columns/summary sections, but when I try using the sample cURL to add a field (after updating the cURL for my sheetID and APIkey), it throws errors. Any idea why this might be happening. Wondering…
-
How can I tell where the automation email fail is coming from?
My IT Dept. says Smartsheets is whitelisted. They show no record of any emails getting blocked. However, my automation is to send an email when a row is added from a form and now no emails are going out to anyone. I even tried Run Now and nothing is going out. Is it Smartsheets? Is it down? It worked two weeks ago when we…
-
I am trying to update an AutomationRule Object and getting an error:
Exception thrown: 'Smartsheet.Api.InvalidRequestException' in smartsheet-csharp-sdk.dll An exception of type 'Smartsheet.Api.InvalidRequestException' occurred in smartsheet-csharp-sdk.dll but was not handled in user code Required object attribute(s) are missing from your request: action.includedColumnIds. in C# the Action…
-
Smartsheet IP Addresses for Network Restrictions
Hi! I am using Smartsheet webhooks to stream events of updates on items Along with hmac authorization, I also want to restrict network access so that requests coming from Smartsheet server will be catered, and all other go unauthorized can I get the set of IPs of Smartsheet?