-
Merged: Update API to support new user subscription model
This discussion has been merged.
-
Data Shuttle: update a checkbox in the source sheet to indicate success
Currently, Data Shuttle efficiently migrates data from Smartsheet to SharePoint, OneDrive, GoogleDrive, Box, & as a Smartsheet Attachment. This Providing a seamless integration between the two platforms. However, one aspect that could enhance user experience and workflow efficiency is the ability for Data Shuttle to…
-
"errorCode": 1002, "message": "Your Access Token is invalid." EU
When I tired accessing the sheet, I was getting invalid access token. But after changing the region [EU]. Now I'm able to access the Smartsheet's' data. Code : import smartsheet # Replace with your actual API key and sheet ID api_key = "Your API key" # Ensure this is a valid API key sheet_id = valid sheet ID (num) #…
-
Bridge - Auto Delete Newly Added Columns
Hello, I've been trying to create a workflow in bridge that when a Move Row automation happens to a target sheet. There are certain columns that will be delete each time the Move Row automation happens. So in this example, the row is moved to this sheet, because the last two columns aren't in the sheet, I want to delete…
-
How can I log a timestamp of a cell change?
I want to add an automation rule to write a timestamp of when a cell value changes, I know I can use the "record a date" automation to get the date but is there any way I can get the exact timestamp similar to the "created at" field in form responses? I am also looking into a way to implement it using the API and there…
-
Does anyone have experience with Celigo to Smartsheet API Syntax?
I am using Celigo but have been stumped on proper syntax to update a row in Smartsheet from NetSuite. I am able to identify the Sheet ID, Row ID, Cell ID but have not been able to successfully update a row. Have tried to use different variations of: rows.id[2691881577385860].cells[17].value with no luck. Thanks in advance…
-
Outlook Calendar integration showing time of event and not just the day,
Smartsheet is great for planning events but when that date is added to an Outlook calendar, it shows up as a day event and not the specific time of the event. Not only does it look like a day event but the inability to change the calendar to the appropriate time of the event is creating more work. It would be great if this…
-
Add Grouping to Report Exports
When exporting a Report to PDF or Excel from Smartsheet, grouping and summary rows should be included. As I utilize a lot of automated reporting, via PDF, this would create consistency in the report view and exported view.
-
Auto Sort sheet using API - Python
I have a code that should work to auto-sort my sheet, but I keep getting the message below. Others have used this script with no problem. Any advice would be greatly appreciated. Error sorting sheet. Status code: 405 "errorCode" : 1122, "message" : "Requested URL does not support this method: PUT", Here is the script I…
-
Auto-sort using API
I understand that as of now it is not possible to auto-sort columns in Smartsheet. But is there an API code that can be used to sort columns alphabetically?