My B48 cell is a dropdown list type. The dropdown list takes its components from another sheet, and they look like: "=IF('Sheet1'!B47 = "no";"answer 1/2/3";"")"
So the B48's list has values only when the value of B47 is "no".
The problem is the following:
When B47 is "no", and you choose one of the answers available in B48, and then you change B47 to "yes" - the value of B48 remains. It doesn't update automatically.
Is there any way I can "fix" this?
Edit: hiding row 48 when B47 is different than "no" is also an option, but I don't know if I can do that either (or how).