is it possible to restrict cell values based upon a different cell?
A simple example of the desired functionality would be that a smartsheet contains two columns, Type and Value.
The Type column has two possible values: Even or Odd. The Value column has 10 possible values: 1,2,3,4,5,6,7,8,9,10.
Based on the value in column Type, I'd like to be able to restrict the choices for column Value. If Type=Even, only 2,4,6,8,10 would be displayed for selection in column Value. If Type=Odd, only 1,3,5,7,9 would be displayed for selection.
Is this possible? If so, please provide a brief description. Thanks!