Formulas - adding formula columns together in a new column

I have 3 formula columns, each calculating a number, which I have formatted using the text(x,"$#,##0.00").
I’d like to add these formula columns together in a 4th formula column ie {formula1}+{formula2}+{formula3}, but this doesn’t work.

  1. Is this because the text function means the value is no longer recognised as a number?
  2. If so, how can I show all formula columns in number format $0.00 and Monday still recognise it as a number?


  1. Yes
  2. I tried using the substitute function but could not get it to remove the “,”.

The easy answer would be to just duplicate the formulas in the fourth column.

Is there a way I can format numbers as $0.00 AND Monday still recognise the field as a number?