-
Get Request for Sheet works, get request for column doesn't?
Any idea why this would be happening Use get request in Postman like so, https://api.smartsheet.com/2.0/sheets/{InsertSheetId} That works but any attempt to grab the columns doesn't like so, https://api.smartsheet.com/2.0/sheets/{InsertSheetId}/columns. Instead, I get this message: { "errorCode": 1006,…
-
Wrong date format while using Power Automate
I went back and forth trying to decide if I should post in a Power Automate Forum or this one so I figured I'd try here first. I have a very simple Power Automate flow. The goal is it grabs employee name and termination date from an email being sent and insert it into a smartsheet row. Everything works as intended minus…
-
Can you use the API to call and get just the first row ID?
I have 10,000K line database and I need just the row ID for the first row -- currently I'm grabbing the entire JSON table to then query for the ID, but that takes a bit of time. Is there a re way to just ask for that first row ID? You can do this for columns like this: first_column = []…
-
Creating rows as children using the API
I've successfully created a Python script to update a sheet in Smartsheets based off a table in postgres. The postgres table updates every hour, so I have the code running every hour after the update. It works great. I have the code set up to create my dataframe, delete all the rows in the sheet, then append all the new…
-
What causes a column ID to change?
Hello, What can cause a column ID to change? We have an integration from one of our software applications to a sheet, and we are having issues because the column ID will change without us knowing. Also, is there a way to see the column ID without having to use the API? For example, through a portal? We opened a ticket for…
-
Web Push Notifications to Windows 10 Notification Center
We have been relying on email to notify people of any Smartsheet notifications they may be receiving as our users are not in the application daily. The problem with the emails is that our company will not add anything to external to our safe sender's domain, so anything from Smartsheet comes along with a huge red banner…
-
Developer Tools
Hello Could you activate developer tools for my account? I need to add an app to work with API using OAauth. I have posted a case #05974342 but it is still without an answer. Thanks, Michael
-
How to setup Bridge Junction for Update Row w/ multiple matches
I am trying to leverage Bridge to update all cells of a column where there is a matched ID between a source sheet and a destination sheet. In this scenario there would be multiple matches in the destination sheet. I'm struggling to determine how the Bridge workflow would identify which rows in the destination sheet to…
-
Software solution using Smartsheet
Hello, My experience thus far with Smartsheet has been as a Systems Administrator for the last four years. Prior to my even learning Smartsheet, I had this idea for an app that would help to streamline a very specific business practice within the higher education industry. The thinking was that I needed to have someone…
-
Bridge Add Row containing Multi-Select Contact Cell
I'm trying to add a row, which contains a multi-select contact cell. The intention is to have this information flow into a column (separate sheet) containing the same configuration. Is this possible with Bridge? In a different workflow, I've successfully used the array function to update the drop-down list of a Contact…
