-
Dropdown List Alternative with Automatic List Update and Dynamic List Features
There have been many requests for improvements to the Dropdown list from Smartsheet Community. The two most typical requests are Automatic updating of the list @Justin Mauzy @Taylor Compton - NOAA Federal Dynamically changing the list of the following selections based on previous selections @Ian Cooper @Mehran Bagherian…
-
Sheet folder Template
1.We have 5 sheets which are interconnected through formulas the whole folder or workspace needs to be saved as new template Note: The formulas should not be removed Is there any way for this? How to create a template set?? Thanks, Keerthana
-
How to Auto-Update Dropdowns in Smartsheet from a Master Sheet?
I am building an Inventory Management System entirely within Smartsheet and need help with dynamically updating dropdown lists. Scenario: I have an Inventory Master Sheet that contains all SKUs. Several sheets (e.g., Sales Orders, Purchase Orders) reference the SKU ID as a dropdown field. I want the SKU dropdown in target…
-
How to Implement Dynamic Dropdown among Two Sheets
A department wanted a way to take a unique list from a project column in one sheet and use that distinct listing as a dropdown for another sheet, which updated every hour. I currently run the below script from Python Anywhere on an hourly basis, and I have shared this script so that anyone else can use it as a template for…
-
Dynamic dropdowns - Waterfall request
The Contact List, Dropdown (Single Select), and Dropdown (Multi Select), are useful tools to control data entry. The problem is they require a lot of maintenance. Through Bridges, we have a sheet that is populated with information from our ADP. It contains all of our employees. Using a Contact List column and selecting the…
-
How to dynamically populate a dropdown box
Hello, I'm new to all of this. I am wanting to have a staff database that is connected to a purchase order database. When a user fills out a form for the purchase order database I want them to be able to select the staff member from a dropdown box that is pulling unique data from the staff database. I cant figure out how…
-
Dynamic/Automatic Dropdowns.
Hello, I am running a major sheet that is the core to the operational running of a Machinery Hire business. All machines have an asset number/description which are currently all manually entered as a drop down so that each machine can be selected in forms and reports etc. I need a simple way to be able to update a master…
-
Dynamic Dropdown
Hello, I maintain a Resource Tracker which includes multiple Resource Names and Vendors. Resources are added and removed on a daily basis. I created a Forecast Tracker for each workstream to update on a monthly basis (total of 12 Workstreams). I'm trying to find a way of keeping both dropdowns 'Resource Name' and 'Vendor…
-
index collect
HI All, I have a formula that i have got working - only issue i have is I have run out of cross reference "space" and cannot add my last spring to complete my function is there anther way to do this Source sheet OR date UP date Site Target sheet Required date Updated Date Site i need to return source sheet UP date, when OR…
-
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?…