API & Developers

Archives for May 2023

Google Cloud Scheduler job
I just took a look at Google Cloud Scheduler which appears to be a free Google service that will run scheduled jobs. This might be a good place for people to run API commands who don't have access to a local system. /marc
Data Shuttle Data Mesh Schedule Run Times
I have issues with my automated systems failing due to timing both with Data Mesh and Data Shuttle. It is necessary that six Data Shuttle workflows run the same time otherwise they occasionally fail due to them fighting over the same certificate when obtaining information from my cloud account. This causes a catastrophic…
Collect information from a changing database
I'm trying to find a way to search for information in a big database, but this database is constantly changing (new sheets imported with the API) The big database are split into 6 imported sheets (250 000 cells approximately on each sheet). This sheet is a list of products. I wanted to do a vlookup on these 6 sheets to…
How to empty a sheet with 8000 rows
Hello, We have a big excel file that we need to auto update on smartsheet. For that, I use the node js API and it's working well. I run this each night. At one moment, it can't run because the sheet is full ( max row is reached ) so I need to empty the sheet before sending new data. I need to keep the same ID of sheet, so…
Does Smartsheet have a Change Management Hub when they have an System upgrade or Planned outage?
I need to know how Smartsheet handles change management that may affects the Smartsheet cloud system. ie. Major upgrade, troubleshooting, bug fix, planned outage, equipment change, etc.
APPSHEET API WEBHOOK
Dear all, I hope this message finds you well. Although I don't have any coding experience, I have been using AppSheet for some time now. Recently, I have been working on integrating Smartsheet into our project management processes, specifically for tracking our projects as a building company. One of our requirements is to…
Using API to update contactlist dropdown
Hello I have a script that pulls names and emails from a report and updates the dropdowns for a contact list column. I have 4 of these columns on the sheet all with the same conditional formatting. For some reason when I run the script it works fine on 3 of the columns but the last one "WorkOwner" I get a bad request…
Best way to disseminate information to multiple customers using Workapps?
Hello! I am looking for a little advice on the best way to approach an issue. We use Smartsheet to store numerous project plans in various workspaces for each customer. We then combine the data - like progress status - to create reports that go up to leadership. We are also being asked to create a means for our customers…
How to send an actual attachment and NOT the link to the attachment
Is there a way to send an attachment to someone in the Contact cell and not the link to the attachment? I don't want to share the sheet with the resources as it has confidential information. When I do the workflow, it sends a link and the user gets an error that they don't have permission since they aren't shared.
How to Generate List of All Smartsheet Objects I can Access?
Hello, I have records management policies and often need to get a list of all of the Workspaces, Sheets, Reports, and Dashboards I can at least view as an account member. I typically use the "Access.csv" report to do this, but it does not include a few useful things. I'm wondering if maybe there are workarounds I can…

Trending in API & Developers

QR Codes/Bar Codes
Dear Smartsheet Community. Is there a means within Smartsheet to allocate a unique QR/Bar Code to a specific line in a grid, such that if you subsequently scan the code (outside of Smartsheet), the specific line/data record can be accessed? For now, I am thinking of an image of the relevant code added in a cell as an…
Moving many rows to another sheet?
My task is to move 3500+ rows to an archive sheet every two weeks. I'm using the python SDK Sheets.move_rows() command but am running into a timeout error (4002) after just 250 rows (granted there are a lot of columns). Can anyone recommend a better method than telling python to loop through the list, moving 250 at a time?…
Bridge Search for a value - What are the modules to use?
I have a use case as follows: When a row changes or is added in the source sheet, I want to search for the row's column named "Key" against a column also named "Key" on a target sheet. If found I want to update a column named "History" in the target sheet that matches the source sheet's key. I also want to write the word…

API & Developers

Discussion List