-
How do I dynamically update a dropdown list?
I want to create a multi-select dropdown list with all future dates and this will be sent out in a form. Currently, smartsheet only offers a date selector with one max date. I was wondering, is there a way to upload values into a dropdown through an API? Otherwise, can I upload values into a dropdown from another sheet?…
-
Dynamic Dropdowns
I've been able to create and update 1500 dropdowns within seconds. I know a big issue in this community is wishing their is some way to update dropdown selections, with a small tweak to my javascript, options array may not contain null elements. FIX: const options = rows.map(x => x.cells.length && x.cells[0].displayValue)…
-
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.
-
Save as new//100 sheet limit - work around?
Hi - Does anyone have a workaround for this? I have a client where i have stripped the workspace back to around 150 sheets - they need to be able to replicate this workspace. I'm getting the same error message when trying to copy the workspace via the API - The end result means that due to this limitation, someone has to…
-
Is aws.relay.smartsheet.com the set of IP addresses that any Smartsheet connections will come from
Specifically I have a client whose security team have forced IP based allow listing on their Salesforce instance, which has of course broken the Smartsheet→Salesforce connector I setup for them. So, are the IPs returned by the aws.relay.smartsheet.com DNS A record the valid list for connections to Salesforce from…
-
Take Multi-Contact from one sheet to another in Bridge
I have a form that users fill in to log risks, they can select multiple risk owners and assign them via a multi contact cell, I then use bridge to auto divert this risk to the respective register.. Unfortunately Bridge does not recognise multi contact to pull into the cell and I get an error.. has anyone been able to…
-
How do add columns in smartsheets dynamically based on a condition ?
I have the date of implementation of the project and I need to dynamically add the columns based on the date. Like for example if I had a 1-2-2024 as my date. It must give ,me 12 months for that date like march 2024 to jan 2025 each column contains 1 month a total of 12 columns and adding to it I have so many projects some…
-
Get hierarchy/parent of sheets
Hi, I came across a blog mentioning that the Sheets folder feature has been deprecated. As SmartSheet users, we now need to migrate our sheet files and folders into workspaces. Additionally, when calling the API to list sheets, it returns all sheets within the account or profile. So, until it will be migrated to a…
-
Severe inconsistencies with token-based pagination in the ListWorkspaces API endpoint
Hello community, I'm experiencing several issues when using token-based pagination (paginationType=token) with the /workspaces API endpoint in Smartsheet: Using the same API Key (so same user), traditional pagination (page and pageSize) correctly returns the full result set (over 300 workspaces) and allows access to all…
-
Allow System Admins to View and Manage All Active API Tokens Across the Enterprise
Description: As a Smartsheet System Admin for our enterprise account, we need the ability to view, audit, and manage all active API tokens created by users in our organization. Currently, admins have no visibility into which users have created tokens, when they were created, what they’re used for, or whether they’ve…