Automation- including something important updating column with a value of other column

I have a scenario in which I have a record which reflects a transaction, let’s say income for a service. I have a column that has already a number- amount of income that is planned. when I change the item status from Planned to be paid to -Paid, I want that the item will move to the group- actual paid, which is fine, and than I want that the value that was in the column - planned income will be move to a different column which is - actual paid, and after that, to delete the value in the original column that was - planned income (deleting column value exist in automation). so it is missing the option to include column a value from other column in this case.

@rony123, if you have Enterprise, you can use the monday Workflow product to do that. If not, you could use something like Make or Zapier or a marketplace app like Column Magic.


Jim - The Monday Man
Get Custom Apps, Integrations & Automations for monday
What is Make & How can it help you with monday?