Use automation to set a value of a column from another column based on a condition.
It is possible to set dates and numbers on meeting a condition (status change, column changed). The value has to be provided as a given value, namely, date or number respectively. It would be great if you allow to set the value of a column by an argument which is provided in another column.
The automation may look like:
If status changed then copy the value of this column from another column