Tip 43: Formula custom fields in Zoho Projects

Tip 43: Formula custom fields in Zoho Projects

The data associated with projects is enormous. It is almost impossible to evaluate data by inspecting every field. With Zoho Projects, performing complex calculations is easy with Formula Custom Fields. Calculations can be done automatically by calling the values from the specified fields. 

 

Consider a scenario where the project owner wants to compute the total cost of inventory. He can create a field for obtaining the cost per unit, the quantity and a custom formula field for finding the product of these values, i.e {COST PER UNIT} * {QUANTITY}.

Their values will be referred in the formula field to calculate the output. You can replace the values with custom numeric fields, numeric values, or expressions. Once these fields are created, they can repeatedly be used to perform similar calculation.

Click here to learn more about Formula Custom Fields.

 

Few points to be noted:

• You can add up to 10 formula custom fields. 
  
• You must enclose the text strings and date arguments within single quotes ('). However, you need not enclose the default or custom field arguments within single quotes (').
  
• The date and time arguments passed into the function must be in mm-dd-yyyy and hh:mm format.