Formula Whisperer is a free prompt. Say what you want a cell to do, in plain words. Get a working Excel or Google Sheets formula, explained piece by piece, plus the edge case that would break it.
It is not always the right tool. Here is when something else wins, and when it does not.
Dedicated tool
Copilot in Excel or Gemini in Sheets
Pick it if
You have the paid add-on and want it inside the sheet.
Pick Formula Whisperer if
You want a formula explained piece by piece with its edge cases, in any free chat model.
0:00The habitA form webhook creates a billing post and a sheet row. Amounts under 1 EUR are tests. Email stays out of the channel.
0:08The recipeTrigger: webhook. Filter: amount >= 1. Actions: sheet append with email, channel post without email. Failure: one FAILED message, stop after two tries.
0:16The testA 0.50 payload stops at the filter. A 40 EUR payload reaches both actions and the channel text has the order id, not the email.
0:24The slotThe sheet credential is named as a slot. The recipe does not contain a key.
No daily video for this drop yet. The in and out lines above are the preview.
0:00The sampleevt_1844, type refund.requested, order 1844, amount 40. Signature header documented as HMAC-SHA256 of the raw body. Retries for 24 hours.
0:08Requiredid, type, data.order_id, data.amount, data.currency. created is optional for the side effect.
0:16IdempotencyStore evt_1844. A second delivery with the same id returns 200 and does not refund again.
0:24The checkCompute HMAC-SHA256 over the raw body with the stored secret and compare to X-Signature. Mismatch is 401 and no side effect. No bypass is described.
No daily video for this drop yet. The in and out lines above are the preview.
0:00Two linesCrontab 30 2 * * 1-5 in New York, and a GitHub cron at 18:30 UTC on weekdays.
0:08The readingThe crontab is 02:30 local, Monday through Friday. That is early morning, not afternoon.
0:16The other hostGitHub's 18:30 UTC is 14:30 in New York on a winter clock and 14:30 minus an hour when daylight saving applies. The agent says to name the season.
0:24The fixFor 14:30 New York weekdays on the crontab: 30 14 * * 1-5. The GitHub line stays, with a UTC comment.
No daily video for this drop yet. The in and out lines above are the preview.
Questions
What are the alternatives to Formula Whisperer?
Copilot in Excel or Gemini in Sheets (dedicated tool); Searching for a formula online (by hand). On One Agent a Day, Automation Recipe Writer, Webhook Contract Writer, Cron to Plain English do a similar job.
When is Copilot in Excel or Gemini in Sheets better than Formula Whisperer?
Copilot in Excel or Gemini in Sheets is the better pick when you have the paid add-on and want it inside the sheet. Formula Whisperer is the better pick when you want a formula explained piece by piece with its edge cases, in any free chat model.
When is searching for a formula online better than Formula Whisperer?
Searching for a formula online is the better pick when your problem is a common one. Formula Whisperer is the better pick when the formula you found returns #N/A on your data.
Tomorrow's drop
Get tomorrow's agent in your inbox
One email when the drop goes up. No digest, no course. Unsubscribe from the beehiiv email whenever you want.
Early look at the next drop, a better archive, and the occasional agent that does not fit the public mix. The daily agent stays free. A custom build is €49–199. Nothing is charged from this form.