The Scenario
Finance sent a message this morning: they need the headcount gap analysis — every open requisition with approved headcount, filled headcount, and the difference — by end of business today for a budget variance review. You have never pulled this from Lever before. You are not sure the gap is even a field or whether you have to calculate it.
The bad version:
- Log into Lever, navigate to requisitions, realize there is no one-click export for the fields finance needs
- Export what you can, open the CSV in Sheets, discover the column names don't match what finance asked for
- Calculate the gap manually with a formula in a new column, rename the headers, and send it over — then get a reply asking why 7 rows are missing
Finance needs this before 5 PM. The variance review has real consequences.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It pulls all open Lever requisitions and writes the fields finance needs — including a calculated gap column — directly into your sheet.
Open a blank Google Sheet and type:
List all open Lever requisitions and write requisition name, status, approved headcount, filled headcount, and team into columns A through D — then calculate the gap between approved and filled headcount in Column E — one row per requisition
What You Get
- Column A: requisition name
- Column B: requisition status
- Column C: approved headcount
- Column D: team
- Column E: gap (approved minus filled), calculated inline
- One row per open requisition
- Closed or archived requisitions excluded unless you ask for them
What If the Data Is Not Quite Ready
Finance needs all requisitions, not just open ones
Export every Lever requisition regardless of status and write name, status, approved headcount, filled headcount, and team into columns A through E — calculate the gap in Column F
Some requisitions have null filled headcount
List all open Lever requisitions and write name, status, approved headcount, filled headcount, and gap into columns A through E — for any row where filled headcount is null, treat it as 0 when calculating the gap and write '0' in Column D
Finance wants subtotals by team
List all open Lever requisitions and write name, status, approved headcount, filled headcount, and gap into columns A through E. Then starting in column G, write a summary table showing team name and total gap — one row per team, sorted descending by gap
Full export, gap calculation, team summary, and flagged rows in one prompt
List all open Lever requisitions and write name, status, approved headcount, filled headcount, and gap into columns A through E. Flag any row in Column F where the gap is 3 or more with the word 'Critical'. Then in columns H and I write a team summary with total approved and total gap per team
Finance gets the detail, the flags, and the summary in one sheet, ready to share.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet for your budget variance review, then ask it to pull the full Lever requisition list with gap calculations in whatever format your finance partner needs. See also the spoke on bulk-creating requisitions or return to the Lever integration overview.