Possible to remove "Multiple select" options if it is selected in another column?


#1

I have two columns that are both “Multiple Select” and have the same options listed. If I have an option selected in Column A, is there any way to remove it as an option from Columnb B?

That is, if the options are “Red”, “Blue” and “Green”, and column A for a record contains “Red”, is there any way to limit the options for column B to just “Blue” and “Green”?