Build or debug Excel/Google Sheets formulas from a plain-English description — with a worked example and the fragile parts flagged.
Spreadsheet task in {{tool}} (Excel/Sheets): {{task}} (what the data looks like — columns, sample rows — and what I need computed or what formula is misbehaving).
If building: the formula, a plain-English walkthrough of each part, a worked example with my sample data, and the fragile parts (what breaks if rows are added, if a value is text-formatted, if names have trailing spaces) with hardening (absolute refs, IFERROR, ranges vs full columns). If a pivot table or built-in feature does this better than a formula, say so with click-path steps. If debugging: the diagnosis, the fix, and why it broke.
Fields like {{ this }} are placeholders — replace them with your own details, or let Aria ask you for them.
This prompt runs with Aria connected to your email, files, CRM and 40+ other services — and you can schedule it to run automatically.
Start Free WeekPull structured data out of messy text — emails, PDFs pastes, reports — into a clean table, with con...
Get the right Excel or Google Sheets formula for your layout — explained part by part, with a worked...
Get a structured first read of pasted data: observations with the numbers cited, trends vs noise sep...
Turn open-ended survey answers into themes and quotes.
Pick the best chart type for what you want to show.
Write or optimise a SQL query from a plain-English description of the data and the question — with t...