Build custom calculations in your reports and compare fields for filtering

We're introducing formula fields and field comparison filters in Ashby, bringing custom calculations and field-to-field comparisons into your reports, dashboards, offer forms, and approval workflows.

This release includes three features:

• General formula fields: Create custom formulas saved as reusable fields across all reporting
• Offer formula fields: Auto-calculate values on the offer form using formulas
• Field comparison filters: Compare one field against another field's value in any filter

General formula fields

Your team wants to track and report on metrics that don't exist as standard fields or must be custom calculations - compa ratios, time-to-hire variants, custom efficiency metrics.

General formula fields, available for Enterprise customers, let you build these calculations directly in Ashby and save them as reusable fields across your reporting.

For example, a compa ratio field that divides salary by the midpoint of the comp range. Pull it into a report and you can immediately see where each offer stands relative to the band, helping your team make informed comp decisions across roles and departments.

To build a field like compa ratio, head to the new formula editor. It supports mathematical, logical, and date functions, and you can use fields from any subject- candidates, offers, openings, interviews - and the resulting field works wherever you'd use any other field.

Other examples include custom time-to-hire calculations (application date to offer start date, measured in days) or derived metrics that combine multiple fields into a single reportable value.

Define a calculation once and it's available to your entire team across reports and dashboards.

Field comparison filters

Field comparison filters let you compare one field against another field's value in any filter.

Standard filters compare a field to a static value you set. Field comparisons evaluate the relationship between two fields dynamically based on each record's data.

Example: you want to surface every offer where salary landed outside the approved compensation band. Every opening has a different range, so filtering by a fixed dollar amount doesn't work well.

With field comparison filters, you filter salary against the opening's compensation range and every out-of-band offer surfaces immediately.

This, of course, works beyond just currency fields.

Compare an interviewer against the job's hiring manager to understand interview load by department, or identify interviews where the candidate's referrer is the same person conducting the interview.

Field comparison filters work anywhere there's filtering - reports, approvals, automations, alerts - get started by finding the search icon in your filters when setting a value.

Available on Plus and Enterprise plans.

Offer formula fields

Offer formula fields auto-calculate values directly on the offer form using the same formula editor. Below, we see a simple bonus calculation.

Any field available to offers can be used as an input to a formula, and derived fields populate and update in real time as your team fills in the form. You also have the option to lock this value if needed.

Common use cases are things like total compensation calculations, bonus derivations, hourly salary equivalents, or any custom calculation your offer process requires.

This is useful for any team looking to standardize derived values on their offers, ensuring everyone sending out offers is calculating the right values without any manual effort.

You can easily see when an offer field is configured with a default field.

We'll also give the option to override (and reset) the default calculated field if needed.

Available on Plus and Enterprise.

Getting Started

The calculations your team runs regularly - comp analysis, time-to-hire breakdowns, process validation - can now live inside Ashby where the rest of your hiring data already is. Every formula you build is immediately available to anyone on your team, in any report or dashboard, without a spreadsheet in between.

General formula fields are available on Enterprise. You can head over to calculated fields in admin to get started.

Offer formula fields are available on Plus and Enterprise. Set them up where you manage custom offer fields.

Field comparison filters are available on Plus and Enterprise and you'll notice a new icon to select a field instead of a static value on your filters.

If you want to learn more about these features you can head over to our knowledge base to learn more:

• General Formula Fields
• Offer Formula Fields
• Field Comparison Filters

You can also book a demo to see these features in action.