Offer Formula Fields Playbook

Build Smart Offer Workflows

Automate Offer Calculations with Offer Formula Fields

In this playbook, you'll explore five Offer Formula Field examples that demonstrate how teams use them in real\-world offer workflows\.

Each section covers a different use case, including why it matters, how to set it up, and what it enables your team to do\.

!Image

!Image

Offer Formula Fields are available on Plus and Enterprise plans

How to use this Playbook

Use this playbook to explore real\-world examples of Offer Formula Fields and spark ideas for your own offer workflows\.

Follow the examples in order, or jump directly to the one that feels most relevant to your team\.

Who this playbook is for

• Recruiting Operations owners building offer workflows and compensation logic
• Admins responsible for configuring custom fields and offer processes
• Talent Leaders who want more consistency and visibility in how offers are structured

Examples you'll explore

Follow each example below in order, or jump to the one that feels most useful for your team right now\.

• Calculate salary into an hourly equivalent
• Convert bonus percentages into bonus amounts
• Compare offer salary to range midpoint with compa ratio
• Flag whether an offer is within band or out of band
• Populate a date only when specific offer criteria are met

!Image

What are Offer Formula Fields?

Offer Formula Fields let you calculate values directly on the offer form using custom mathematical or logical operations\.

They’re useful when you want to automate offer math, reduce spreadsheet work, and keep key calculations inside Ashby\.

!Image

Where do I find Offer Formula Fields in Ashby?

!Image

You create Offer Formula Fields from your offer custom fields in Admin\.

Start in Organization Setup, open Custom Fields, then use the Offer tab to create or edit a field and add a calculated default value\.

Before you dive in

📚 Want a deeper dive on formula syntax, supported functions, or setup guidance?

Explore the Offer Formula Fields article in the Ashby Knowledge Base\.[](https://www.ashbyhq.com/resources/terms-ai-features)

[Button: Continue →]

Hourly Equivalent

Calculate salary into an hourly equivalent

What it does

Converts the compensation field your team already tracks in Ashby into an Hourly Equivalent value on the offer\. In this example, we’re using Salary\.

Why it's useful

Gives your team a quick way to translate annual compensation into an hourly rate\.

• Compare compensation in a format that is easier to use for hourly or wage\-based workflows\.
• Reduce manual math when you need to convert salary into an hourly equivalent\.
• Reuse the value anywhere your team needs a quick hourly reference\.

!Image

How the formula works

We start with Salary because that is the annual amount we want to convert\. Then we divide by 2,080, which is a common estimate for full\-time working hours in a year \(e\.g\., 52 weeks in a year x 40 hours a week\)\. We use round so the result is easier to read and behaves more like a normal currency value\.

The result is a simple hourly equivalent that your team can review directly on the offer\.

We use round so the result is easier to read and behaves like a normal currency value\.

*Formula: round\(\{Salary\} \ \(\{Bonus %\} / 100\), precision: 2\)

We start with Salary because that is the offer amount we want to compare\. Then we use mean on Compensation Range to get the midpoint of the range and divide Salary by that midpoint to calculate the compa ratio\.

We use round so the result is easier to read and compare, like 1\.00 or 1\.05\.

**Formula: if\(\{Clawback Applies\} = true and tonumber\(\{Sign\-on Bonus\}\) > 0, dateadd\(date: \{Start Date\}, amount: 365, interval: "days"\), null\)`

[Button: ← Return ]