Go to your Pipeline

Pipeline CRM Help Center

Search for any help questions or topics.

Calculated Fields

Avatar
Maria Herrell
Updated 1 year ago

Calculated fields allow you to have the data in your custom fields calculated from data hosted in other fields. Calculated fields currently support system and custom fields that are numeric, currency, and date fields.

Creating Calculated Fields

To create a Calculated Field, you must be an Administrator for your account

1. Go to Custom Fields in Account Settings

2. Click to add a new field for the desired record type and select Calculated Field from the dropdown.
 

3. From there you will give the field a name and select a custom field group if you desire.

4. To calculate, select a function first. You can choose from sum, subtract, multiply, divide, Arithmetic and Comparison functions. Then, select the fields to calculate, system or custom. Separate each field with a comma and close the parentheses.

To select a system or custom field, you can type @[Name of the field]

5. Finally, you will choose the output value. 

Once the custom field is saved it will automatically calculate the values that are already entered. You can return to your saved list, add the newly created column, and see the calculated field in action!

Types

Functions


SUM
SUBTRACT
MULTIPLY
DIVIDE
MIN
MAX
ROUND
ROUNDUP
ROUNDDOWN
DATEIF
DAY
WEEKDAY
MONTH
YEAR
DATE
EDATE
WEEKNUM

Arithmetic


+

-

*

/

%

^

Comparison

Logical

IF
AND
OR
NOT
SWITCH
String

CONCAT
SUBSTITUTE
CONTAINS
LEFT
RIGHT
MID
LEN
FIND
Collection

INCLUDE
ALL
ANY
Did this answer your question?
😞 😐 😃