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.
Typing over a drop down box
Basic question team but fo the life of me cant work it out!
ย
I have some coloumns with drop down boxes, but i want to somehow ensure that users do not type in the cell, but make it that they HAVE TO choose an option in the drop down list.
ย
Right now they can choose from the list, or type ANTYHING they want in the cell, which kind of defeats the purpose of the drop down.
ย
Thanks all
Kylie
Comments
-
Kylie,
ย
According to this thread:
https://community.smartsheet.com/discussion/restrict-input-only-values-drop-down-list
ย
the target for data validation is 2-3 months.
ย
There is currently no way to restrict them from typing what they want. Some posters here have suggested a column to check if the entered value is valid - depending on how many choices there are that could be messy.
ย
Craig
ย
-
Sweet - thanks Craig
Helpful as always!
