-
Sheet history with deleted rows
When we synchronize a Smartsheet sheet with another application and delete a row, sometimes the row cannot be deleted in the other application due to business rules, and we must restore the row’s data. Additionally, sometimes when a row is deleted, we need to send specific data from a cell, but we no longer have access to…
-
Has anyone been able to successfully upload a .pdf file to a row using VBA?
Hello, I've been able to load a .pdf file to a specific row on my sheet. However, the file isn't converted correctly when using MS Access 16 VBA on Windows. I've tried using bytearray, ADODB.stream, Base64 encoded, and multiple other variations that AI has recommended, but I'm not able to read the uploaded file using any…
-
Restrict dropdown options as an option for forms
There should be a way to restrict dropdown options on forms that are external facing that also have internal uses without setting up additional reference or separate internal/external columns. Use cases for our team in particular would be project type and add-ons. We have different customers using different forms on the…
-
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…