-
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…
-
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"…
-
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.
-
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:…