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.
GCavin
(Gilles Cavin - Reinventing Formulas in monday.com)
2
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”), “”)