-
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…
-
Create Automation Rules with API
It would be convenient if we were able to actually create automation rules via the api rather than just modify. It would also be nice if the API automation functionality was improved, it's pretty limited.
-
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…
-
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?
-
Merged: Update API to support new user subscription model
This discussion has been merged.
-
How can I use API to attach a local PDF to a Smartsheet row through Kofax/Tungsten?
I've been trying to figure out how to configure Kofax's Call REST Web Service step so I can use an API to attach local PDFs to specific rows of a Smartsheet. I keep hitting dead ends or examples for everything besides PDFs. Anyone out there know how to accomplish this task?