I'm am trying to write a formula where when a class it turned on or off it replaces the data in that cell. Does anyone know if there is a way to do that.
I essentially have multiple part numbers for a part and when the color changes the part number changes. Each color is on its own class, so I would love for our Bill of materials worksheet to auto populate the part number when the class is turned on or off.