This topic will walk you through how to add a formula to a new or existing field.
Workflow Designer formulas enable you to build complex logic calculations directly into your workflow configurations. This reduces manual data entry in launch forms and gives legal teams confidence that the data in their contracts is calculated correctly.
For a walkthrough of example formulas and more information on supported Formula types, refer to the Formulas Help Center.
Add a Formula
- Click the Workflow Designer tab.
- Select the workflow you want to update.
- Click the Document tab.
- If you do not have an existing field that you want to add the formula to, create a new field.
- If there is an existing field that you want to add a formula to, select it in the Fields and Conditions panel. You can do this by clicking the three stacked dots, and then Edit Field.
- In the Fields and Conditions panel, click the plus sign located under the Formula section. The formula builder appears.
- Select the formula function you want to apply. Once you have selected the formulas you want to use, guided text displays to walk you through how to populate the field with the correct inputs.
- Click Done.
Workflow Designer’s formula builder supports the following operator notations:
- [a] + [b] → Add([a], [b])
- [a] - [b] → Subtract([a], [b])
- [a] * [b] → Multiply([a], [b])
- [a] / [b] → Divide([a], [b])
- [a] > [b] → GreaterThan([a], [b])
- [a] >= [b] → GreaterThanOrEquals([a], [b])
- [a] < [b] → LessThan([a], [b])
- [a] <= [b] → LessThanOrEquals([a], [b])
- [a] == [b] → Equals([a], [b])
- [a] and [b] → And([a], [b])
- [a] or [b] → Or([a], [b])
Multiply() and Add()
You can calculate the Total Contract Value by multiplying the Hourly Rate with the Number of Hours and adding Add On 1 and Add On 2: Add(Multiply([HourlyRate], [NumberOfHours]), [AddOn1], [AddOn2])
You can calculate Subscription Expiry Date by adding the Subscription Start Date and the Subscription Term Length (in months): RelativeDate([SubscriptionStartDate], [SubscriptionTermLength], “months”)
You can calculate Number of Contract Days between the Start Date and the End Date: DateDiff([StartDate], [EndDate])
For more information on formulas, refer to the Formulas Help Center.