When Status Changes, Copy Formula Column to Number Column

[joe.morgans (Joseph Morgans)]

Hi, I want to copy the value in a formula column over to a number column when the status changes. Does anyone know a plugin which can do it?

So far I have tried:
Autoboost
General Caster
Column Magic

I think the problem is the formula column is driven by a lot of mirror and summary columns, and these plugin do not support it. I have a formula column on the main item which is driven from a Summary column (lots of subitems added together), and then added to two numbers in the main item.

Just to explain, the reason I need to do this is so if item prices change in the future, it won’t affect the ACTUAL TOTAL of previous Purchase Orders. That way my graphs and tables for spending history will not be skewed if a price changes on an item.

Any help much appreciated!

[GCavin (Gilles Cavin - Reinventing Formulas in monday.com)]

Hi Joseph,

You should be able to achieve what you want with the Advanced Formula Booster. You may even do it without a formula column and maybe without mirror columns at all (it has the ability to sum sub-item values, read values from other boards, etc.).