Pulling cost from one column when another column's status changes to X

I am trying to gauge how much a projects cost has changed during different stages. We only have one column for cost which is updated. How can I say when status in column A says “Ordered” retrieve number listed in column Value?

I did an IF statement which just constantly updated my totals instead of at certain stages. I need it to only trigger when certain status is selected.

Hi @Jeanette,


I did a formula similar but with some formatting of text however I found that every time the Value (Contract Value) was updated then the formula column was updated. I only want the formula column to update when status is changed then not change again.

Here is the formula I used: IF({Onboarding}=“Proposal”, TEXT({Contract Value}, “$#,##0.00”), “”)