-
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…
-
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…
-
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…
-
Linking Columns of 2 Sheets to Feed into a 3rd
Hi There, I believe this should be fairly simple, however the steps are lost on me. In particular I am looking to take a single column from two seperate sheets and have them feed into a third. In this instance I am taking a Request Form (office supplies, multiple options from drop-down to cell) and an Inventory Form (cost…
-
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…
-
Dropdowns with multiple levels filters
Please, Do introduce dropdowns whose options are filtered by previous options! This is a massive feature that prevents most of my projects being fully moved to Smartsheet! It would be a great addition that would change the game for lots of us!
-
Parsing Multi Picklist through API
Hi everyone, I just started working with the SmartSheet API. So far, everything has been straightforward, except one thing; I am trying to submit new rows to a sheet but can't seem to get the value of the Multi Picklist right. If submitted as a string in various formats, the value only displays as one long tag including…
-
Syntax: Add Row via API for Multi Select Contact Column, MULTI_CONTACT
Dropping this here in the hopes Google picks it up for future developers. At times when you cannot use the SDKs for adding rows via the API with multi-select contact columns (i.e. Bridge), the following body payload syntax is correct for posting new rows to a sheet. [ { "cells": [ { "columnId": 4532552246972292, "value":…
-
Formula continuously updates cell even though values are not changing
Certain combinations of results are continually updating even though the value/result didn't change. Every time I open the sheet, it requires me to save but I didn't change anything. Combinations with issue: "Utility, Telecom, Waste" and "Utility, Telecom" Combination without issue: "Utility, Waste" Services column is…
-
I am trying to create a formula - multi selection dropdown menu and between two dates.
I am trying to create a formula to count how many "A" in in the dropdown menu column which you can select multiply answers. I also need this formula to look at the 1st quarter only of 2025. Any information will be appreciated. =COUNTIFS([THREAD]:[THREAD], HAS("A", AND([Date Submitted]:[Date Submitted], >=DATE(2025, 1, 1),…
-
Alphabetized Filter Dropdowns
It would be helpful if the "is one of" dropdowns in filters were alphabetized instead of listed in the order of most used. For dropdowns that have many different options, it is hard for team members to find the option they need in a filter when it isn't alphabetized. Example of Today Red (52) Green (43) Yellow (28) Blue…
-
IDEA for Copy Row Automation: Also Copy Assigned Dropdown Value Colors
If Colors in a dropdown column are setup (In Table View), the Copy Row automation should retain those same colors when copied to the new sheet. Just like how cell colors copy over, I'd like those assigned colors to copy as well.
-
Option to Multi-select or Select All for Conversations on a row
There are instances when I want to alert the team (or a subset of users) to particular new actions that I need feedback on in a row, but an automation would be too broad. At the moment I have to click each user individually, then go back to the list to select the next person. It would be helpful to be able to either…
-
copy data from excel and enter into smartsheet with multiselect column
I have a report in Excel that I want to transfer regularly over into Smartsheet for dashboard reporting. One of the columns is a dropdown list that allows for multiple values. I am having trouble formatting it to where when copied from Excel, it paste into Smartsheet as the selected values. When I copy/paste, the cells…
-
Multi-select drop down wrap text
Currently if you have multi-select drop down in a column, even if you have wrap text chosen in the column, it does not. To keep the column narrow, half my drop downs are cut off. Would be a great update to have that column able to wrap.
-
If Then Help
If a cell in Column A (titled Job) equals Marketing (from drop down in Column A), then adjacent cell in Column B (titled Responsible) equals Susan (name from contact list). I want someone to choose from a drop down in Column A, then based on their choice a particular person receives an email. Column A is set for multiple…
-
Smartsheet Salesforce Integration: "Value is not supported for this column Type."
I have created Workflow for bi-directional sync in the Smartsheet Salesforce Connector between Salesforce and Smartsheet. In Salesforce, I have a Lookup(User) field named "Assigned To" and in Smartsheet, I have a corresponding "Assignee" column with the Multi-Select Contact List data type. When I update the "Assignee"…