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