How do I create a formula or workflow to auto select 1 columns value based on another columns value?

I have 2 columns that I was to use together to provide a sort of checks/balances system for missing information. See columns and values example outline below:

Column 1:

Value 1

Value 2

Value 3


Column 2:

Value 1

Value 2

Value 3


The Values would be the same under both columns, but when a value or values are selected under Column 1 I want to unselect them in Column 2. So with that I would want to have all the values selected under Column 2 automatically. For example, to start column 2 will have all 3 values checked off/selected - then at some point when Value 1 under Column 2 is selected then I would want Value 1 under Column 2 Deselected.

I'm not sure if there needs to be a hierarchy created in order for this to work but if so I would say having column 1 be the parent column between the 2 would be best.

Thanks for your help!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!