Formula Fields allow you to automatically calculate numbers and dates using information already stored in Wealthbox. Rather than manually calculating values or updating fields, you can create formulas that automatically display results based on information from a record.

For example, you can use Formula Fields to calculate how long someone has been a client, how many days have passed since their last activity, or a client's estimated net worth.

Note: Formula Fields are available on Premier and Enterprise subscriptions.

What are Formula Fields?

Formula Fields are a type of custom field that perform calculations using information from other fields on the same record.

Formula Fields can be created for:

• Contacts: Including people, households, companies, and trusts.
• Opportunities: Calculate values using opportunity amounts, probability, and dates.
• Custom Objects: Create calculations using supported custom fields.

Formula Fields automatically update when the information used in the calculation changes.

For example, if you create a Formula Field to calculate net worth using a contact's assets and liabilities, the result will automatically update whenever either value changes.

Note: Formula Fields can return a number or date. They cannot display text or calculate information across multiple records.

How do I create a Formula Field?

Account Owners and Administrators can create Formula Fields in Wealthbox.

1. Click the three-dot menu in the upper-right corner of Wealthbox.
2. Navigate to Settings.
3. Select Custom Fields.
4. Choose the record type where you'd like to add the field.
5. Click Add Field and select Formula as the field type.
6. Enter a name for your Formula Field.
7. Enter your formula in the formula editor.

8. Review the Example Output to preview the calculation.

   

   

9. Save your Formula Field.

When creating a formula, type { in the formula editor to view and select available fields.

For Custom Objects, navigate to the appropriate Custom Object type and select Fields & Layout to create a Formula Field.

Once saved, the Formula Field will calculate its value automatically for applicable records.

How do I create a Formula Field using AI?

Wealthbox also offers Fill with AI, which can help you create formulas using natural language.

Instead of writing a formula manually, you can describe what you'd like to calculate, and Wealthbox AI will generate a suggested formula for you.

To use Fill with AI:

1. Navigate to the Formula Field editor.
2. Hover over the formula input box.

3. Select Fill with AI.

   

4. Describe the calculation you'd like to create.
5. Review the suggested formula and its example output.
6. Save the Formula Field once you're satisfied with the result.

For example, you could enter:

Calculate the number of days since a client's last activity.

Wealthbox AI can suggest:

DAYS_SINCE({Last Activity Date})

You can also use Fix with AI to help correct an invalid formula or Undo Last Edit to reverse an AI-generated change.

Note: Fill with AI is available when AI features are enabled for your account. AI-generated formulas should be reviewed before saving.

What information can Formula Fields use?

Formula Fields can reference supported fields within the same record.

All supported record types

Formula Fields can use:

• Currency custom fields
• Number custom fields
• Percentage custom fields
• Date custom fields
• Created Date
• Updated Date

Contact records

In addition to supported custom fields, contact Formula Fields can use the following information:

Special Dates

• Birthdate
• Anniversary
• Client Since
• Date of Death

If a contact has multiple entries for the same special date type, the most recent date is used.

Activity Dates

• Last Activity Date
• Last Note Date
• Last Task Date
• Last Event Date
• Last Phone Call
• Last Dropbox Email Date
• Last Mail Merge Date
• Last Modified

Only the most recent activity dates are supported. Upcoming activity dates cannot be referenced.

Additional Information

Formula Fields can also use supported numeric and date fields from the Additional Information section of a contact record.

Examples include:

• Gross Annual Income
• Assets
• Non Liquid Assets
• Liabilities
• Adjusted Gross Income
• Estimated Taxes
• Estimated Net Worth
• Estimated Liquid Net Worth
• Tax Bracket
• Tax Year
• Retirement Date
• Occupation Start Date
• Signed Fee Agreement Date
• Signed IPS Agreement Date
• Signed FP Agreement Date
• Drivers License Issued Date
• Drivers License Expires Date