API and Developers
Discussion List
-
Pull FROM Reference Link
Dear Community, i have a question, is there anyway to pull the Form link automatic into a sheet or call it by API? Of course i understand that is i have multiple Forms in One Sheet i have multiple adress Like Sheet 1 Adress 78654654 Form A — 4788 Form B — 47654 Is there any logic in the adress so we can match it and pull?
-
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…