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. …
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 au…
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 Marke…
Is there a way to change the background color of the dropdown bubbles? On the main report, everything is in its own gray dropdown bubble, which is best for black text. However, when I run a report, th…
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 …
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 learn…
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 buildi…
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…
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…