-
Autofilling Forms
Currently we can use querystring parameters to autofill form values (e.g. https://app.smartsheet.com/b/form/18f38f1ef40223457f7afe19cc0beba5d15?Field1=Value1%Field2=Value2) , which is an extremely useful feature. However, for authenticated forms, the querystring values are dropped during the authentication process if the…
-
Create Triggers Module Issue
I have a series of sheets that I need to create triggers for that I am trying to scale via automatic trigger createion. We have a custom module in Bridge for both Create Triggers and Create Templatized triggers. I've tried using both, and while it says completed in the run log, they do not show up on the identified…
-
Snowflake EXPLAIN query support with Snowflake JDBC Driver
Is there a way to run an EXPLAIN snowflake query through the JDBC driver with the Snowflake extension? I am running net.snowflake snowflake-jdbc 3.12.8 and it throws an error saying net.snowflake.client.jdbc.SnowflakeSQLException: SQL compilation error: syntax error line 1 at position 15 unexpected 'EXPLAIN'.. I see there…
-
Any way to get cell history other than one cell at a time?
Working to clean up after Control Center's built-in archiving functionality made a mess of one of our archive sheets (but that's a story for another time). Basically, the archiving function duplicated some rows as it moved them to the archive sheet, anywhere from 1 to 5 times each. I need to go through and clean up the…
-
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…
-
Move a row to a new sheet based on an entry on a separate sheet
Hello, My company has a sheet titled active employee roster which has every employee in the company. We are trying to create a new Offboarding sheet that will then find the employee on the Active Employee roster sheet and then move them to a 3rd sheet labeled Offboarding Archive. I am struggling to create a solution for…
-
How to eliminate leading apostrophe from values when updating columns via API
Hi, I currently have a C# application that updates a few smartsheets and am struggling with leading apostrophes in most columns I'm updating. All of the columns are marked as Numeric/Text, and all data types of values being pushed are varchar/strings. However it seems that if the value being pushed does not contain any…
-
Sharing Dynamic view on MS teams Tab
I recently created a dynamic view that I wanted to share within my Microsoft Teams Tab after attaching it showed me this I decided to add it to a dashboard and then bring it to MS Teams Tab but I got the same response. I am trying to figure out a way my team can have access to their views and make changes through MS Teams…
-
Can I change the email that Smartsheet sends emails from using the API
I have a Bridge workflow set up and I'm calling the Send Rows API call to email out what I need. The problem I'm running in to is I don't want the emails coming from my email address. I've tried to save it using a service account to see if it would send from there instead but still shows mine. Any ideas how to change that?
-
Row Link Column
Inside Row Properties, with the API, and with Bridge, you can extract the row specific URL. It would be very helpful if that was just a system column like created or modified.
