Hey all, I'm currently working on a list in which for every item I have a Calibration Result, which tells me if a gas detector passes, doesn't pass, or if the calibration wasn't done. And then I have a 'Condition' column which is meant to justify the first column i mentioned.
Is it possible to limit the choices of the second column based on the first column's answer? I need for example for the Condition column to only show the 2 red background choices if the first column also has the red background choice (Doesn't pass). Thanks in advance.