Question

Formula Error

  • 12 February 2024
  • 12 replies
  • 49 views

Badge +1

Getting an error within a template that reads as:

The Tab formula is not valid. A number numerical tab LocalePolicy does not match the LocalePolicy of another number numerical tab in the same formula.

I am having trouble pinpointing which formula field is causing the issue - is there anywhere I can see more detail regarding the error or even where to resolve it? 

I’ve double checked and triple checked all formulas, and when I make edits, I’m allowed to save and close the template. 

 

Any and all insight would be greatly appreciated!


12 replies

Userlevel 1
Badge +6

Hello @anmol.sharma,

 

Thank you for reaching out here in the DocuSign Community.

 

I apologize for the inconvenience that this might cause you, I know the importance of having the envelopes that you sent sorted and filtered as needed; I understand that you have a user that you want to filter the envelopes using a custom field.

 

The error means that there is a formula tab with a formula that references two numerical tabs with Number validation whose locale policies don’t match, however, a manual review will be needed.

 

If this is a template would it be possible for you to provide a copy of the template?

 

To download a document from a template, navigate to the TEMPLATES page. Locate the desired template and click on its title to open the Template Details view. In the documents panel, click on the document thumbnail image to initiate the download. Use the browser controls to download or print the document PDF if it opens in a browser window. To download a document from a template

 

Or at least a template with a blank document with the formulas that you used.

 

If this is an envelope created from scratch, please try the below troubleshooting:

 

  • Clear cache/cookies
  • Try a different browser(s)
  • Try an Incognito window
  • Try a different device
  • Try a different Internet network, such as on a mobile device using data with Wi-Fi disabled.
  • Try using VPN, or if on one already, disconnect from VPN and try again
  • Please try the Alternative Signing Method

 

Note: Some advanced features and options are supported only in specific DocuSign plans. Your account plan might not support some options discussed in this help topic. Contact your account administrator for more information about which options are available for your account. Or, visit our Plans and Pricing web page for more details on the features included with your plan. Compare eSignature plans & pricing.

 

Let us know if you need further assistance with this.

 

Best regards,

 

Christopher | DocuSign Community Moderator

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

Badge +1

Hello @christopher.alpizar ,

I appreciate you reaching out and responding to my question. 

The error is occuring upon sending and/or trying to send the template to a user, and all of the value fields being referenced in the Formula have the same validtion, font, font size, and formatting to showcase them as numbers as opposed to differences between currency and numbers. 

I have reached out in a private message but also attached the template for your review here as upon attempting the troubleshooting tips, the issue still does not appear to be resolved. 

Any and all insight you be able to share would be greatly appreciated - Thank you!!

Userlevel 1
Badge +6

Hello @anmol.sharma,

 

Thank you for reaching back, the system is not allowing me to download the file, would it possible to sent it again in a DM?

 

Let us know if you need further assistance with this.

 

Best regards,

 

Christopher | DocuSign Community Moderator

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

Badge +1

Hi @christopher.alpizar, I private messaged you earlier as I am unable to attach files through messages - if you could respond at your earliest convenience that would be greatly appreciated 

Userlevel 1
Badge +6

Hello @anmol.sharma,

 

I found that it was the formula of the second part value that was prompting the error message, my question is are all the total values for all of the six parts meant to have a formula field? or just the first two?, am currently working to try to find what is wrong with the actual formula for the second part.

 

Let us know if you need further assistance with this.

 

Best regards,

 

Christopher | DocuSign Community Moderator

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

Badge +1

Hi @christopher.alpizar ,

All of them are meant to have a formula field, I was trouble shooting independently and deleted all original formulas, and started building out the formulas from scratch again once the error began to pop up

It was working fine last week, and I’m not sure what changed over the weekend to prompt the error

Userlevel 1
Badge +6

Hello @anmol.sharma,

 

Would it be possible for you to provide an envelope ID for one of the envelopes that was successfully sent using this template?

 

As a recipient/signer, there are several ways to find the Envelope ID. One way is to open the email notification and right-click on the "REVIEW DOCUMENT" button, then select "Copy Link Address" and provide the link to the support expert. Another option is to locate the Access Documents security code in the footer of the email notification and provide it to the support expert. If you are unable to access the email notification or the signing/viewing session, you can try to locate the Envelope ID in the upper left-hand corner of each document if you have previously downloaded them. If none of these methods work, it is recommended to reach out to the sender of the envelope.

 

How do I find an Envelope ID as a recipient/signer?

 

Let us know if you need further assistance with this.

 

Best regards,

 

Christopher | DocuSign Community Moderator

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

Badge +1

@christopher.alpizar here is a envelope ID that was successful in generating the envelope using the template

985BD340-3E4E-4E35-8AC0-AE381D22AE54

Userlevel 1
Badge +6

Hello @anmol.sharma,

 

If you Save as Template, the envelope that was successfully sent and try to edit and use that template, do you get the same error?

 

Save as Template allows you to quickly create a template from a previously prepared envelope. The template includes all envelope data, recipient properties, message information, advanced options, documents, fields, and field properties. To save an envelope as a template, locate the envelope on the Manage page, click the action menu, select Save as Template, make any desired edits, and save and close the template.

 

Let us know if you need further assistance with this.

 

Best regards,

 

Christopher | DocuSign Community Moderator

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

Userlevel 1
Badge +6

Hi @anmol.sharma,

 

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 or if the information that was provided was useful.

 

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,

 

Christopher | DocuSign Community Moderator

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

Badge

I am having a same issue with an envelope that has formula.  Powerform works with no issue but when sending the envelope to specific address, I get the below error message.   Did this get resolve? 

 

Userlevel 1
Badge +6

Hello @KCMO Ret,

 

Thank you for reaching out here in the DocuSign Community.

 

If you Save as Template, the envelope that was successfully created using the Powerform and try to use that template, do you get the same error?

 

Let us know if you need further assistance with this.

 

Best regards,

 

Christopher | DocuSign Community Moderator

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

Reply