-
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…
-
Smartsheet API and Automation Rules
Hi all, I'm having some difficulty using the smartsheet API with Python. I am trying to use smartsheet_client.Sheets.copy_sheet(...) to copy a particular sheet by its ID and copy it to a new destination folder. It works fine, I can create the sheet in the new location and with a new name, carrying over whatever data was in…
-
Activity log of all smartsheet usage under my admin
Is there an API now or some way to find the last time a smartsheet was accessed? I don't want to have to traverse the settings behind each smartsheet and export a report one-by-one. I didn't see any recent threads about some API access to that information. Thank you!!