I am trying to create an automation or workflow that would allow the board data in particular dropdown columns to all be cleared unless the dropdown contained a particular value.
For example clear column Wednesday 13th unless the drawdown contains the value “OFF”.
Right now I can clear the column but it clears all the data including the “OFF” value, which would be helpful to leave.