-
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?…
-
Best practice for dynamic update of dropdown list
We use dropdown lists quite a bit for our filters and dashboards and function. E.g., we track work by campaigns. However, some campaigns are added and some drop off. What are best practices for managing work that needs to be tracked in a master sheet where the drop down categories need updating once in a while?
-
Dynamic Dropdown List
Has anyone created a workaround or built a solution that provides dynamic dropdown lists?
-
Formula as alternative to Dynamic dropdown menus?
Hello, I have seen in previous discussions that dynamic dropdown menus are not available without a third party app or Data Shuffle. Neither of those are options right now, so I am trying to do the next best thing. My situation is this: I have two sheets , the first sheet is a a project specific sheet that has the task…
-
Dynamic dependent dropdown list
Hi I'd like to make dynamic Dropdown list depending on the value of another column (in the same sheet), like currently available in excel, see https://www.ablebits.com/office-addins-blog/create-dynamic-dependent-drop-down-excel/ Is there any option available beyond Bridge by Smartsheet I do not have the license for? Thanks…
-
Dynamic Dropdown Lists Driven by Formulas
Hi all, Is it possible to dynamically populate dropdown lists in Smartsheet based on the contents of another column or sheet (like dependent dropdowns in Excel)? If not natively, are there creative formula-based or automation workarounds users have found effective for keeping list options up to date as data changes?…
-
Scatter plot chart - labels & values on both Axis, plotting combined Value vs Effort score intersect
Can you provide the capability of creating a true a decision matrix/SWOT where we see the names of projects and their combined Value vs Effort scores? This is company standard across all industries and company that enables the decision makers to compare and evaluate ideas/initiatives against one another. This type of SWOT…