-
Shortcut for counting lots of items in multi-select column?
Hi all! I know how to do this manually but am hoping someone has a shortcut! I have a sheet with a very long dropdown list of college majors for employees who have signed up for a particular program. It's a multi-select field since many people had more than one major, and they can also type in a response if their major…
-
is there a maximum numebr of options to be on a dropdown list?
Hi- I was wondering why formats are not being updated with th information that I'm adding on the columns corresponding to that field?
-
Dropdown list
Hello! I have a Smartsheet document with columns that have dropdown lists. When I enter a value into one of these columns that is not already available in the dropdown list, I want that value to be automatically added to the dropdown list without having to manually edit the list. Is there a way to set this up so that new…
-
Copy and Pasting Multiple Rows from Excel into One Multi Dropdown Select Cell in Smartsheet
Good Morning fellow smartsheeters!!! Is it possible to copy and paste multiple rows from excel into one cell in smartsheet when that cell is apart of multi dropdown select? For my use case, Each Market as an offer associated with it in column D. So essentially these markets in column c are grouped by the Offers in Column…
-
One template with scroll down options for different timings of tasks
Dears, As we know making formulas in duration time is not possible, so I'm looking for other option to make life easy in below scenario: We have several production plants, producing different product types and using different packaging pritnters which has influence on overall project timing for new product introduciton. I…
-
COUNTIFS, HAS, and CONTAINS Formulas with Different Reference Sheets and Dropdowns!
Hi all! Looking for some expertise with COUNTIFS, HAS, and CONTAINS formulas when also using reference sheets with dropdowns. I have one reference sheet that my team is using to track employee's learning progress with class enrollments and completions. One of the columns is set up to be an Enrollment Status dropdown with…
-
How to Structure Formulas so if dropdown options change, it auto-updates?
I am trying to compile metrics and get them to auto-update to reflect the values of a drop down. For instance, if the drop down has options like "Physical Exam", "Digital Exam", "Advanced", I'm building columns in my metrics sheet to tabulate the totals for each using countif statements (for each respective month). E.g.:…
-
Contact List and Drop down List values can be referred using a reference from a different sheet
For Contact List and Drop-down list columns currently the values need to be added and updated individually in all columns and sheets eventhough the values are common for many columns and sheets. If we have a provision to have the values referred using a reference from a different sheet, then we can add or update the values…
-
summing a number column if a certain selection is matched in a multiselect column
I have an Expense Intake sheet that has a multiselect column "Ships" where any number of ships can be selected; "Ship 1", "Ship 2", "Ship 3" etc. I also have a "Cost Per Ship" column on that sheet and a Month Column on that sheet On my budget set up sheet I am trying to figure out how much was expensed to Ship 1 in…
-
Multi-select Dropdown and multiple values
Hi community! Looking for some guidance please! :) I need a column capturing the number of specific job roles associated with project. e.g. Job Roles ---- Product Manager Delivery Manager Software Engineer Software Engineer Tester Tester I don't think this can be done via a multi-select dropdown with multiples of the same…