Skip to main content
barak
Newcomer
Newcomer
July 25, 2024
Solved

How to add a currency symbol (e.g. $ or €) to a formula field result

  • July 25, 2024
  • 2 replies
  • 396 views

Hello

I have formulas that total prices on a template

I’d like to present the result as a price -- ie with a currency symbol up front.

I can hack this by adding a $ into the underlying template PDF or doc.. but I’m hoping there is a simple way to tell the formula field to prepend a $ to the number.

Thank you in advance

-barak

Best answer by Michael.Rave

@barak

Formula fields only return a number or a date and cannot be set up to include a currency symbol.

However, it is fairly easy to set up and achieve the currency symbol being present in the document:

  1. Add a text field and assign it to the same recipient as the formula field
  2. Add a $ sign into the new text field
  3. Make the text field “read-only” so the recipient can’t change it
  4. Test it and if needed change position of the field to look nice

2 replies

Michael.Rave
Docusign Employee
Docusign Employee
July 26, 2024

@barak

Formula fields only return a number or a date and cannot be set up to include a currency symbol.

However, it is fairly easy to set up and achieve the currency symbol being present in the document:

  1. Add a text field and assign it to the same recipient as the formula field
  2. Add a $ sign into the new text field
  3. Make the text field “read-only” so the recipient can’t change it
  4. Test it and if needed change position of the field to look nice
"Select as Best" below if you find my answer is a valid solution to your issue and mark it as resolved.
Docusign Employee
August 10, 2024

Hi @barak,

 

I hope you are doing well.

I would like to confirm if you were able to solve your issue by utilizing the solution that was suggested?  If so, please mark it as the best answer by clicking “Select as Best” to make it easier for other users to find. Otherwise, feel free to let me know and I will gladly help you address the situation as soon as possible.

Best regards,   

Alejandro R. | Docusign Community Moderator   

"Select as Best" below if you find the answer a valid solution to your issue!