-
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.
-
How to do Countifs when drop down allows multiple select
Hello, I am trying to set up a formula that would count a contract number that is in a cell that allows multiple drop downs. I have looked up "Has" and "Contains" and I am pretty sure I am just following the formula wrong? Can anyone help?
-
Sum cells with multiple options from dropdown only
Hello, I would like to sum up costs only for cells that have multiple homegrown fruits within a single month. In this example, January's sum would be $3,500. I've tried a few formulas and thought I got it with the below, but it doesn't look like it's accurate. Does anyone have any recommendations? =SUMIFS({Inventory -…
-
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…
-
Counting occurrences of values in a multi-select dropdown list
I have looked through all of the answers for this topic, and still cannot find a solution that works for me. I have a sheet with a multi-select dropdown used to code responses. In another sheet, I want to count the number of times a certain value appears in any dropdown in the sheet column. Here is my formula:…
-
Isolate User Entered Value in Multi select list
I have a multi-select list that looks like the below. My goal is to map form results to a PDF and I've used helper columns to turn the responses into checkboxes [formula for those: =HAS([Indicate the type of referral source]@row, "Yes, parent")]. However….I do not have the multi-select limited to my answers so that staff…
-
Restrict dropdown options as an option for forms
There should be a way to restrict dropdown options on forms that are external facing that also have internal uses without setting up additional reference or separate internal/external columns. Use cases for our team in particular would be project type and add-ons. We have different customers using different forms on the…
-
Gathering total number of Yes/no responses into one column out of a certain number
I have a multiple drop down cells from a "form" i set up that either have Yes or No as responses. What Im trying to do is to have a cell at the end that provides a number of how many yes there are and give me that total number.