How to change currency of 'Forecast Value'

Hi All,
How do I change the currency of the ‘Forecast Value’ column? Presently my ‘Deal Value’ is in GBP but the ‘Forecast Value’ is in USD (however it is showing the correct value for GBP).

Clicking on ‘Column Settings’ presents me with the formula box (the coding bit(?)).

I’m new to Monday.com so apologies for the basic question.

Thanks for all of your help.

Hi @njw :wave:

Welcome to the Community!

Are you perhaps using the Sales Pipeline template here?
If so, you can simply replace the formula in the box with the formula below:

CONCATENATE("£",({Deal Value}*{Close Probability}))

The CONCATENATE function will allow you to add any currency symbol of your choice!

I hope this helps! Remember to mark as solved if this answers your question :smiley:

Best,

Dani

Hi @njw :wave:

I hope the answer above was helpful for you!

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

Hi @njw

I hope the answers in this thread are useful!
As we haven’t had any updates here, I’m going to go ahead and mark this thread as solved.
This means that the thread will close in 7 days time :slightly_smiling_face:

If you have any additional questions or you feel your original query wasn’t resolved, please feel free to let us know and we’ll be happy to continue to assist!

Best,

Dani