If x Then x in columns

Alice_H

Hello,

Using drop down choices in columns, is there a way to take a column with a certain data value, & then in the following column, only certain choices appear in the drop down choices found there, out of many?

Example:

Entire set of Data consists of: A,B,C,1,2,3

Column 1: If you select A, only options 1 & 2 can be selected in Column 2.

Column 1: If you select B, only options 2 & 3 can be selected in Column 2.

Column 1: If you select C, only options 1 & 3 can be selected in Column 2.

Thanks very much!

Mike Wilday

There is no ability to limit dropdown options based on an IF statement. Sorry. It would be a great feature. You could submit a Product Enhancement Request. 

Alice_H

Thank you, Mike!