How to use formula fields in Zoho Writer
Overview
Zoho Writer allows you to insert formulas in documents to perform calculations on the fly. You can add formulas in paragraphs, tables, and merge and fillable templates. These formulas can be manually updated by the user.
Steps
How to add formula in a paragraph
- Open the document where you wish to add the formula.
- Click the hamburger icon, go to the Fields tab --> Dynamic Fields --> Formula.
- In the New Formula dialog that opens:
- Choose the desired function from the Choose Function drop down and the + icon to select the fields, to configure the desired formula.
- Choose the Format Number option to format the formula result.
- Click Insert.
How to add formula to a table
- Click the table cell where you wish to add the formula.
- Click the hamburger icon, go to the Fields tab --> Dynamic Fields --> Formula.
- In the New Formula dialog that opens:
- Choose the desired function from the Choose Function drop down and the + icon to select the fields, to configure the desired formula.
- Choose the Format Number option to format the formula result.
- Click Insert.
Note: You can also click the Table Settings when hovering over the table and choose the Formula option in the Table Options panel to insert a formula.
How to add formula in merge templates
You can insert formulas in repeat blocks in merge templates to automatically perform calculations based on the number of rows being added.
Steps
- Click the table cell in the repeating region where you wish to add the formula.
- Click the hamburger icon, go to the Fields tab --> Dynamic Fields --> Formula.
- In the New Formula dialog that opens:
- Choose the desired function from the Choose Function drop down and the + icon to select the fields, to configure the desired formula.
- Choose the Format Number option to format the formula result.
- Click Insert.
Note: You can also click the Table Settings when hovering over the table and choose the Formula option in the Table Options panel to insert a formula.
How to add formula in fillable templates
You can insert formulas in fillable templates to dynamically calculate the values based on the filled responses.
Steps
- Place the cursor in the fillable template where you wish to add the formula.
- Click the hamburger icon, go to the Fields tab --> Dynamic Fields --> Formula.
- In the New Formula dialog that opens:
- Choose the desired function from the Choose Function drop down and the + icon to select the fields, to configure the desired formula.
- Choose the Format Number option to format the formula result.
- Click Insert.
Note: You can also click the Automate tab and click Formula under the Advanced Fields heading.
Troubleshooting
1. Error/Symptom: Cannot format the formula's output. For example, the formula returns 10000, but I need it as 10,000.
Reason: This might happen if the formula's Number Format is not configured correctly.
Solution: Please ensure the Number Format for the formula is configured correctly.
2. Error/Symptom: Unable to format the formula's result like 122 to $122.00 with currency and decimals.
Reason: It could mostly be because the Number Format is not configured correctly.
Solution: Check the Number Format configured for the formula.
3. Error/Symptom: When I use formulas in documents, the formatting breaks. The formula should return $4.250,00 but it returns 4.25.
Reason: The most common reason is the document's locale is not configured correctly.
Solution: Set the appropriate document locale to apply the correct currency.
Related Articles
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
New to Zoho Writer?
Create. Review. Publish.
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
How to use DATEDIF formula in Zoho Writer
Overview The DATEDIF function in Zoho Writer allows you to calculate the difference in days, months, or years between two dates. You can insert the DATEDIF function in paragraphs, tables, and merge and fillable templates in Zoho Writer. Syntax ...How to setup fields in fillable templates in Zoho Writer
Overview A fillable template in Zoho Writer is a document designed with interactive form fields that allow users to enter, edit, or submit data directly within the document, just like filling out a digital form. There are 20 field types that are ...How to use NPV, PV, and FV formulas in Zoho Writer
Overview Zoho Writer lets you simplify financial planning and budgeting with the NPV (Net Present Value), PV(Present Value), and FV (Future Value)functions. These functions help you calculate the value of your investment over a specific period of ...Getting started with document merge in Zoho Writer
Overview Template-based document generation in Zoho Writer allows you to automate the creation of personalized documents by connecting pre-designed templates with structured data sources such as spreadsheets, forms, CRMs, or APIs. Each template ...How to refer formula output across a document
Overview Zoho Writer lets you reference the formula's result across your document and perform calculations based on the formula's result. You can insert the formulas in paragraphs, tables, and merge and fillable templates. Steps Place the cursor in ...
New to Zoho LandingPage?
Zoho LandingPage Resources