-
Now Announcing - Linked Dropdown Columns!
November 05, 2025 Dynamic Dropdowns has long been the #2 most voted public product request. When we hear customers talk about dynamic dropdowns we hear them talk about two specific needs: Available Now - Linked dropdown columns: Keep dropdown lists across many sheets in sync In Planning - Dependent logic in dropdowns:…
-
Returning matches in Multi-Select column for exact match of value and excluding "Value" + "Text"
I am seeing if I find a match for a value in a multi select column and using the HAS formula. It is returning when the string is found, but also when a string plus additional words is found. For example I am looking for if the color "red" has been selected in the column, but it is also pulling in when "Red Rose" has been…
-
Update Columns API Possible Bug - unable to clear all options in a MULTI_PICKLIST column
NOTE: I tried to file this several times a support ticket, but the AI BOT was unable to create a ticket and the OG Support Portal no longer allows the direct creation of tickets. Grrrrrr. ISSUE: It appears that the Update Column API PUT https://api.smartsheet.com/2.0/sheets/{sheetId}/columns/{columnId} fails to work as…
-
Form with multi drop down answers - need help to count correct choices
Hi All, I have built a post training test form for a colleague, some of the questions have got multi answer choices (e.g. correct answers can be A, B, C, D or even choice of E - stating that all previous choices are correct; or could be that A,C,D are correct). If correct choice is chosen, needs to return point 1 per each…
-
This is a question about multiple selection able to run report and auto counted and group in report
I asked this question before, but hope things might be updated, we currently only can run report based on a single section in the column, correct? or can we run report in multiple selection
-
One of my criteria is one of many listed in a dropdown column and CONTAINS/HAS are eluding me.
Hello! I am working from a single "Master Sheet" and utilizing INDEX/COLLECT to pull the desired info onto separate sheets. I am utilizing "Feature", "Level" and "Product Line" as my criteria, however the "Product Line" is a multi-select dropdown column with anywhere from 1-10 values in it depending on the products usage.…
-
Dropdown menu & how to separate results
I have a dropdown menu to select a choice of up to 19 out of a possible 42 items, each item selected needs to be separated into its own column as each selection is mapped. The way the mapping has been set up is the first selection in dropdown needs to be at position 1 even if it is the 4th option and the second selection…
-
Summary Sheet & Filter based on Form Responses with Multi-Select Dropdown
Hi all! Hoping for some assistance with a summary formula pulling in criteria from a multi-select dropdown response form... I have a dashboard that has a form embedded in it to allow the user to enter their desired criteria (see below screenshot) and then the bottom of the dashboard pulls in the metrics using the form…
-
How to generate Report from Dropdown list data
I am trying to run a report and group them from the drop-down list data in the sheet. However, when I try to group them out by each list that I have in the dropdown column, it is not available for me to choose. It is also not available for me in the Summary. Anyone know how to use the Group and Summary function in the…