Adding Dollar Sign to formula column

I created a formula column and I want to display the dollar sign in the column. I used the text option for the dollar sign but when I did that, only one of my formula columns worked and the other one is showing an error. Is there a way to automatically have the $ present like I can do with the number column? Thanks your help!

@nado2oo2 Welcome to the Monday community!

You can use this function:
image

Full list of Monday.com Functions and other formula related info.

Hope this helps! Let me know if you still need help formatting this.

2 Likes

Hi @nado2oo2 :wave:
Welcome to the Community!

It look like this post here Adding Dollar Sign to formula column - #2 by andrewalmand might have answered your question, is that correct?

If so, please don’t forget to mark it as the solution so other users can easily find it, and to close this thread :slightly_smiling_face:
If not, feel free to ask any additional questions you have!

Best,
Dani

I am trying to added a dollar sign to my formula, but I am confused with how the TEXT part sits within the formula. My formula is a simple subtraction of two number columns, and I need the result to have a dollar sign. Can someone share with me how I would write this forumula?

@janelegall

Basically:

TEXT({Num1}-{Num2},"$#,##0.00")

Jim - Subscribe to The Monday Man
Watch Our Latest Video: monday.com Mirror Columns in Integromat - the Basics
Check out our monday apps, now in beta: The Monday Man Apps

@JCorrell

Am I right, that this is only working when using $? It simply removes the currency sign when using €.
How can I use € instead?

@Kenny

When possible, the preferable method is to simply do the required calculation then set the unit by clicking into the column summary (if you don’t have the column summary displayed, add it back temporarily).

This is not always possible. To use TEXT() formatting function with a different currency symbol do something like this:

"€" & TEXT({Num1}-{Num2}, "#,##0.00")

It’s not perfect. The formatting for numeric values in formula columns could do with some upgrades.

Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: Keep your Integromat scenarios from timing out! - YouTube
Contact me directly here: Contact – The Monday Man

@JCorrell
I can live with that. Thank you very much!

Hi, this is my formula IF({Stage} = “Verbal”, SUM({Value}), " ") How would I add the $ to this formula? Thanks.

@rachelmele

Here are 2 examples:
IF({Stage} = "Verbal", "$" & SUM({Value}), "")
IF({Stage} = "Verbal", TEXT(SUM({Value}), "$#,##0.00"), "")


Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: Should I convert my Integromat account to Make? - YouTube
Contact me directly here: Contact – The Monday Man

Actually monday has built-in support to show the unit, you don’t need any TEXT in your formula. Just go to the column summary at the bottom and set the unit! It seems like something that should be at the top under column settings, but it is in the footer.

image

2 Likes

@rachelmele

@cberman is correct. That is definitely the preferred method! (As I wrote in the Mar 3 post.)

However, it doesn’t work in every situation.

Using the TEXT function works for a singular formula column but if I try to add two similar formula columns together it errors (I assume becase it now treats them as TEXT columns?)

Using the TEXT function works for a singular formula column but if I try to add two similar formula columns together it errors (I assume becase it now treats them as TEXT columns?)

@ashley_unltd

One way is to reproduce the formulas that you want to add in the new formula:
For example:
{formula 1} = 1/2
{formula 2} = {number} * 3
{formula 3} = (1+2) + ({number * 3)

Another is to use SUBSTITUTE() to remove the extraneous characters:
from above… {formula 3} = SUBSTITUTE(SUBSTITUTE({formlula 1}, "\$", ""), ",", "") + SUBSTITUTE(SUBSTITUTE({formlula 2}, "\$", ""), ",", "")

OR

SUBSTITUTE({formlula 1}, "[\$,]", "") + SUBSTITUTE({formlula 2}, "[\$,]", "")


Jim - The Monday Man (YouTube Channel)
What is Make & How can it help you?
We Create Custom Solutions