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% automa...