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:
Full list of Monday.com Functions and other formula related info.
Hope this helps! Let me know if you still need help formatting this.
1 Like
Hi @nado2oo2 
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 
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?
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
Am I right, that this is only working when using $? It simply removes the currency sign when using ā¬.
How can I use ā¬ instead?
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
1 Like
@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.
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.
6 Likes
@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?)
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
Hi Jim, hereās another one Iād appreciate your help with.
If Iām simply multiplying one column by another and want a $ sign in the formula column what would I add to:
MULTIPLY({ACV},{Years}
Thanks.
Something like thisā¦
TEXT(MULTIPLY({ACV},{Years}), "$#,##0.00"), "")
I canāt find a solution for my issue either. I got 2 columns , one {Qty} one {Sales Price} , and another column with a dropdown menu with different currencies we operate ($āā¬,ā¦)
Im trying to make a formula that multiplies Qty*Sales prices, and add the string value of the dropdown menu so i can dynamically change the outputted currency on the value in a quote builder tool.
Thanks !
Try something like this:
{dropdown} & ({Qty} * {Sales Price})
Jim - The Monday Man
Get Custom Apps, Integrations & Automations for monday
Thank you!! The AI said use āFORMAT_NUMBERā which wasnāt working but this did like a champ!
Here is how i used it: TEXT({Cost}*{Quantity},ā$0.00ā)