Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Dropdown only options
If I have set up a dropdown, can I disable users from typing in text. I ONLY want people selecting from the dropdown.
Comments
-
I don't know of a way to prevent this.
You could setup a conditional formatting rule that says:
"if column A is {select all dropdowns} & click the 'Apply format when condition is NOT met' button.
Change the background to Red & Text White.
Then you can easily see inputs that are not your dropdown values.
-
Great tip!!
-
Hi Erica-- I've also gone ahead and added your vote to support data validation to our enhancement request list, as the addition of this feature would prevent this issue from happening
-
Fantastic! Thanks.
If your list includes being able to hide rows (not just columns), that would also be great.
This discussion has been closed.
