It will be great to be able to create a custom automation where user can either clear or set one or more column values based on another column. As an example, when status changes to X clear column A and set column B to Y.
You can do that (although not all column types can be set) with
Not sure if the recipe criteria / clauses where recently updated or added, but when I had check the clear column clause was not available. Thanks for your reply/help above. I was trying to reset/clear the time tracking based on certain item status and can now create the automation recipe.