Want to be able to track depreciation of an asset over its lifespan or have a way to automatically determine priority level for work requests? These options and MORE are now available with our Formula Custom Fields feature. For more information on this, see some of the examples below, or contact your Customer Success Manager today!
Most commonly used formulas:
- Math Operators – Division and Multiplication
- Math Operators -- Subtraction and Addition
- Text Function - Includes
- && (And): Determines if both values are true.
- Logical Operators - Or
Example #1: Math Operators - Division and Multiplication
Division: On the request:
Division: Formula:
Multiplication: On the Request:
Multiplication: Formula:
To build this formula, you will need two number fields and another field to build out the equation (product field). From here you can build out the general math equation using the divide function, dividing the two number fields, and then the multiplication function, multiplying the total by 100 to give you the percentage.
Example #2: Math Operators - Addition and Subtraction
On the request:
Formula:
Example #3: Text Function - Includes
This operator determines if an array includes the given value.
On the request:
Formula:
This formula allows you to flag certain words or characters to trigger another field. In this example, we tagged the resource Gym to trigger the field "Do you need the basketball hoops lowered?". To build this formula, you will want to use the “Includes” function and then add in the options from the previous field that would like to include.
Example #4: && (And): Determines if both values are true.
This formula will auto generate a response in one field if two other fields have been selected. If you want “x” & “y” to equal “z” and populate a new field.
On the request:
Formula:
Example #8: Logical Operators - Or (||)
This will be if one or the other is true, then it will populate that in the field. This can typically be combined with other functions that are listed above (such as And && or Ternary ?). It allows you to have multiple options for determining fields.
On the request:
Formula
Example #9: Math Operators - Straight Line Depreciation
The simplest method of calculating depreciation is to take the net asset value and divide it by the number of periods (usually years) of useful life. This can be done by using the Math Operators.