All ideasMore in Work
Work

My dot said the spreadsheet passed 27 checks. It broke in Google Sheets.

Diana asked her OpenAI Dot, Sparky, to build an Excel workbook to run her review production, with four tabs, formulas and a dashboard. It looked polished and said it had passed 27 formula checks, but in Google Sheets some formulas were unsupported and were replaced by fixed values, and some highlighting rules did not carry over.

This only partly worked. Read what happened before you try it.

How it works

  1. Ask for a workbook with Instructions, Content Tracker, Test Results and Dashboard tabs, with formulas and verification
  2. The dot builds four tabs with filters, validation and three charts
  3. The dot reports it passed 27 formula checks
  4. She opens it in Google Sheets
  5. Some formulas are unsupported and are replaced by their last values, and some highlighting rules are unsupported

Why it’s worth knowing

The workbook checked itself in the place that built it, not in Google Sheets where she works, so its pass meant little.

Where it’s from

Summarized from a public post on aiagentslibrary.com. See the original ↗

Upgraded prompt

A ready-to-use prompt for this idea, built from research on what makes AI agents do the job right: who the AI should be, the exact steps, and a check to make sure it was done the way you wanted.

1Who the AI should be
2The prompt, with the steps
3The check when it’s done
Upgraded prompts are coming soon.

Try next

WorkA contractor talks measurements into his phone and QuickBooks sends the estimate in 45 secondsWorkThe AI audited my eBay store, found 28 listings going nowhere, and sold a bundle for meWorkRead every job advert, tailor my CV and apply with my approvalWorkForemen file the daily log with a three-minute phone call, and the agent chases anyone who forgets30 min saved

Every idea is a real post from someone who tried it, summarized in our words, with a link to the original. App names are swapped for plain words.