This seems like something that would be handled with formulas, but not quite.
Edit: More simple example of another similar thing I want/need
I have a single select for the status of an item (Shipping, installed, inventory). This should be 100% automated by other values. For instance, if a barcode value is captured for the row, the status should change to “inventory”.
I am attempting to track laptop repairs. I currently have a column (COL-A) with a “Multiple Select” that lists “missing parts”. I have another column (COL-B) that also has “Single Select” that lists for instance, how much RAM a unit is, “0 Gb, 2 Gb, 4 Gb, …”
What I would like to do, let’s say I change the value of (COL-B) to say a laptop has 4 Gb of memory and select that, I want a particular option removed from the multi-select on (COL-A)