Conditional Drop-down list columns
Is it possible to have the the drop-down list of a column changed based on the value of another column?
Eg. If column A's value is set to "Work stage 2" column B's drop-down list will have a specific list, but when it is set to "Work stage 2" column B's drop-down list changes automatically to a different list.
Say Column A has a drop-down list of:
Work stage 1
Work stage 2
Work stage 3
Work stage 4
Column B has a drop-down list based on the value selected in Column A.