Skip to main content

I have a document that has 4 columns with 32 lines each and need totals at the bottom and another place in the document that has an additional 4 columns with 32 lines each.  I’m trying to find out if I can create a formula that will add automatically such as the excel field =sum(1:32).  How do I create it in DocuSign?

Thank you for any help.

Hello ​@Anita,

Thank you for reaching out, and welcome to the Docusign Community! We appreciate your question and assure you that we are fully committed to providing you with the best service possible. 

With the Formula field, you can build formulas to calculate a value based on number or date fields in your document. When the recipient completes the underlying fields, the Formula field automatically calculates and displays the result.

Formula fields support standard mathematical operators (addition, subtraction, multiplication, and division), signs to evaluate mathematical inequality (<, >, <>, <=, and 😆, and a set of Date functions to calculate a number of days or determine a date.

Note: To learn more about calculated fields and best practices, see Building Advanced Templates: Become a NIGO Ninja Series Part III from Docusign University. You will be prompted to log in using your Docusign email and password to access this content.

Relevant article:

Calculated Fields
Add a Formula Field to a Document

 

If you found the response to be a useful solution to your question, please mark it as the best answer by clicking “Select as Best” to make it easier for other users to find. Thank you!

 

Best regards,

Ma. Cassandra | Docusign Community Moderator

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


Hello ​@Anita,
 

I hope you are doing well. 

I want to confirm if you were able to solve your issue by utilizing the suggested solution or if the information provided was useful.

Let me know and I will gladly help you address the situation as soon as possible.


Best regards,
Ma. Cassandra | Docusign Community Moderator

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


No I haven’t yet.

 

My document has 4 columns with 32 lines each.  I want to sum each column at the bottom and using the formula Total Hours 1 + Total Hours 2 … is very lengthy.  Is there a way to set a formula that is comparable to what is used in Excel where the formula can be =sum (Total Hours 1:Total Hours 32)?


Hello ​@Anita,

 

I hope you are doing well.
I understand that you would like to have a way to set a formula comparable to Excel's. Unfortunately, the formula only applies to the fields, not the document.
Docusign doesn't have a function to sum a range of fields like Excel does, because it is designed for document signing and basic calculation.

 

Best regards,
Ma. Cassandra | Docusign Community Moderator

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


Reply