All AutosheetBench tasks

Fix broken formulas and validate amounts

Data operationsHardDeterministic scoringLatest run

Passed by 5 of 12 products on their best model: Autosheet in Excel, Claude in Excel, Claude Code + Sheets MCP, Claude in Sheets and Claude Code + Autosheet MCP.

Prompt and starting spreadsheet

Task files

Prompt

Several formulas are broken — can you find and fix them?

Also add data validation to the Amount column so only positive numbers are allowed

Starting spreadsheet

Sheet1
ABCDEF
1InvoiceVendorAmountTaxTotalStatus
2INV-001Acme Corp12500162514125Paid
3INV-002Brite Solutions840010929492Pending
4INV-003Clearview Tech9800#REF!#REF!Paid
5INV-004Datasync Ltd15200197617176Approved
6INV-005Evergreen Supply76008368436Pending
7INV-006FastTrack Inc-3200#VALUE!#VALUE!Disputed
8INV-007Global Traders11000#VALUE!#VALUE!Paid
9INV-008Horizon Partners6750877.57627.5Approved
10INV-009InfoSystems13400174215142Pending
11INV-010JetPro Services#REF!#REF!#REF!Paid
12INV-011Keystone Group9200119610396Approved
13INV-012Luminary Co71009238023Paid
14INV-013Mercer Dynamics-450#VALUE!#VALUE!Disputed
15INV-014NovaTech18600#VALUE!#VALUE!Pending
16INV-015Omega Supplies59007676667Approved

A passing output

Autosheet in Excel · Opus 5.5
Sheet113 cells changed

D4=ROUND(C4*0.13,2)

ABCDEF
1InvoiceVendorAmountTaxTotalStatus
2INV-001Acme Corp12500162514125Paid
3INV-002Brite Solutions840010929492Pending
4INV-003Clearview Tech9800127411074Paid
5INV-004Datasync Ltd15200197617176Approved
6INV-005Evergreen Supply76008368436Pending
7INV-006FastTrack Inc-3200-416-3616Disputed
8INV-007Global Traders11000143012430Paid
9INV-008Horizon Partners6750877.57627.5Approved
10INV-009InfoSystems13400174215142Pending
11INV-010JetPro Services00Paid
12INV-011Keystone Group9200119610396Approved
13INV-012Luminary Co71009238023Paid
14INV-013Mercer Dynamics-450-58.5-508.5Disputed
15INV-014NovaTech18600241821018Pending
16INV-015Omega Supplies59007676667Approved

How each AI configuration did

7 of 22 passRun files
Excel and Sheets · All types · All models · All outputs

Pass criteria

All must be met, checked automatically.
  • D4:E4, D8:E8 and D15:E15 hold the expected values, in an accepted form
  • Rows 7 and 14: a negative amount kept, or corrected to positive, with its tax and total, in an accepted way
  • C2:E16 show no errors
  • C2:C16 only accept numbers greater than a set value

Passed 7

Autosheet in Excel Opus 5.5 · Medium

Passed27s · 9¢
Sheet113 cells changed

D4=ROUND(C4*0.13,2)

ABCDEF
1InvoiceVendorAmountTaxTotalStatus
2INV-001Acme Corp12500162514125Paid
3INV-002Brite Solutions840010929492Pending
4INV-003Clearview Tech9800127411074Paid
5INV-004Datasync Ltd15200197617176Approved
6INV-005Evergreen Supply76008368436Pending
7INV-006FastTrack Inc-3200-416-3616Disputed
8INV-007Global Traders11000143012430Paid
9INV-008Horizon Partners6750877.57627.5Approved
10INV-009InfoSystems13400174215142Pending
11INV-010JetPro Services00Paid
12INV-011Keystone Group9200119610396Approved
13INV-012Luminary Co71009238023Paid
14INV-013Mercer Dynamics-450-58.5-508.5Disputed
15INV-014NovaTech18600241821018Pending
16INV-015Omega Supplies59007676667Approved

Autosheet in Excel Sonnet 5.5 · Medium

Passed25s · 6¢
Sheet113 cells changed

D4=IF(ISNUMBER(C4),ROUND(C4*0.13,2),"")

ABCDEF
1InvoiceVendorAmountTaxTotalStatus
2INV-001Acme Corp12500162514125Paid
3INV-002Brite Solutions840010929492Pending
4INV-003Clearview Tech9800127411074Paid
5INV-004Datasync Ltd15200197617176Approved
6INV-005Evergreen Supply76008368436Pending
7INV-006FastTrack Inc-3200-416-3616Disputed
8INV-007Global Traders11000143012430Paid
9INV-008Horizon Partners6750877.57627.5Approved
10INV-009InfoSystems13400174215142Pending
11INV-010JetPro ServicesPaid
12INV-011Keystone Group9200119610396Approved
13INV-012Luminary Co71009238023Paid
14INV-013Mercer Dynamics-450-58.5-508.5Disputed
15INV-014NovaTech18600241821018Pending
16INV-015Omega Supplies59007676667Approved

Claude in Excel Opus 5.5 · High

Passed52s · 29¢
Sheet147 cells changed

D2=C2*G2

ABCDEFG
1InvoiceVendorAmountTaxTotalStatusTax Rate
2INV-001Acme Corp12500162514125Paid13.0%
3INV-002Brite Solutions840010929492Pending13.0%
4INV-003Clearview Tech9800127411074Paid13.0%
5INV-004Datasync Ltd15200197617176Approved13.0%
6INV-005Evergreen Supply76008368436Pending11.0%
7INV-006FastTrack Inc-3200-416-3616Disputed13.0%
8INV-007Global Traders11000143012430Paid13.0%
9INV-008Horizon Partners6750877.57627.5Approved13.0%
10INV-009InfoSystems13400174215142Pending13.0%
11INV-010JetPro Services00Paid13.0%
12INV-011Keystone Group9200119610396Approved13.0%
13INV-012Luminary Co71009238023Paid13.0%
14INV-013Mercer Dynamics-450-58.5-508.5Disputed13.0%
15INV-014NovaTech18600241821018Pending13.0%
16INV-015Omega Supplies59007676667Approved13.0%

Claude in Sheets Opus 5.5 · Medium

Passed1m 8s · 22¢
Sheet132 cells changed

D2=IF(ISNUMBER(C2),C2*$I$1,"")

ABCDEFGHI
1InvoiceVendorAmountTaxTotalStatusTax Rate13.0%
2INV-001Acme Corp12500162514125Paid
3INV-002Brite Solutions840010929492Pending
4INV-003Clearview Tech9800127411074Paid
5INV-004Datasync Ltd15200197617176Approved
6INV-005Evergreen Supply76008368436Pending
7INV-006FastTrack Inc-3200-416-3616Disputed
8INV-007Global Traders11000143012430Paid
9INV-008Horizon Partners6750877.57627.5Approved
10INV-009InfoSystems13400174215142Pending
11INV-010JetPro ServicesPaid
12INV-011Keystone Group9200119610396Approved
13INV-012Luminary Co71009238023Paid
14INV-013Mercer Dynamics-450-58.5-508.5Disputed
15INV-014NovaTech18600241821018Pending
16INV-015Omega Supplies59007676667Approved

Claude Code + Sheets MCP Opus 5.5 · Medium

Passed1m 4s · N/A
Sheet122 cells changed

E2=IF(C2="","",C2+D2)

ABCDEF
1InvoiceVendorAmountTaxTotalStatus
2INV-001Acme Corp12500162514125Paid
3INV-002Brite Solutions840010929492Pending
4INV-003Clearview Tech9800127411074Paid
5INV-004Datasync Ltd15200197617176Approved
6INV-005Evergreen Supply76008368436Pending
7INV-006FastTrack Inc-3200-416-3616Disputed
8INV-007Global Traders11000143012430Paid
9INV-008Horizon Partners6750877.57627.5Approved
10INV-009InfoSystems13400174215142Pending
11INV-010JetPro ServicesPaid
12INV-011Keystone Group9200119610396Approved
13INV-012Luminary Co71009238023Paid
14INV-013Mercer Dynamics-450-58.5-508.5Disputed
15INV-014NovaTech18600241821018Pending
16INV-015Omega Supplies59007676667Approved

Claude Code + Autosheet MCP Opus 5.5 · Medium

Passed1m 59s · N/A
Sheet131 cells changed

D2=IF(C2="","",C2*0.13)

ABCDEF
1InvoiceVendorAmountTaxTotalStatus
2INV-001Acme Corp12500162514125Paid
3INV-002Brite Solutions840010929492Pending
4INV-003Clearview Tech9800127411074Paid
5INV-004Datasync Ltd15200197617176Approved
6INV-005Evergreen Supply76009888588Pending
7INV-006FastTrack Inc-3200-416-3616Disputed
8INV-007Global Traders11000143012430Paid
9INV-008Horizon Partners6750877.57627.5Approved
10INV-009InfoSystems13400174215142Pending
11INV-010JetPro ServicesPaid
12INV-011Keystone Group9200119610396Approved
13INV-012Luminary Co71009238023Paid
14INV-013Mercer Dynamics-450-58.5-508.5Disputed
15INV-014NovaTech18600241821018Pending
16INV-015Omega Supplies59007676667Approved

ChatGPT in Excel GPT-6 Luna · High

Passed2m 2s · 2¢
Sheet113 cells changed

D4=C4*13%

ABCDEF
1InvoiceVendorAmountTaxTotalStatus
2INV-001Acme Corp12500162514125Paid
3INV-002Brite Solutions840010929492Pending
4INV-003Clearview Tech9800127411074Paid
5INV-004Datasync Ltd15200197617176Approved
6INV-005Evergreen Supply76008368436Pending
7INV-006FastTrack Inc-3200-416-3616Disputed
8INV-007Global Traders11000143012430Paid
9INV-008Horizon Partners6750877.57627.5Approved
10INV-009InfoSystems13400174215142Pending
11INV-010JetPro ServicesPaid
12INV-011Keystone Group9200119610396Approved
13INV-012Luminary Co71009238023Paid
14INV-013Mercer Dynamics-450-58.5-508.5Disputed
15INV-014NovaTech18600241821018Pending
16INV-015Omega Supplies59007676667Approved

Failed 15

Autosheet in Excel GPT-6 Astra · Low

Failed19s · 17¢
Sheet110 cells changedWrong value

D4=C4*13%

ABCDEF
1InvoiceVendorAmountTaxTotalStatus
2INV-001Acme Corp12500162514125Paid
3INV-002Brite Solutions840010929492Pending
4INV-003Clearview Tech9800127411074Paid
5INV-004Datasync Ltd15200197617176Approved
6INV-005Evergreen Supply76008368436Pending
7INV-006FastTrack Inc-3200-416-3616Disputed
8INV-007Global Traders11000143012430Paid
9INV-008Horizon Partners6750877.57627.5Approved
10INV-009InfoSystems13400174215142Pending
11INV-010JetPro Services#REF!#REF!#REF!Paid
12INV-011Keystone Group9200119610396Approved
13INV-012Luminary Co71009238023Paid
14INV-013Mercer Dynamics-450-58.5-508.5Disputed
15INV-014NovaTech18600241821018Pending
16INV-015Omega Supplies59007676667Approved

Why it failed: 3 cells show an error.

Autosheet in Sheets Opus 5.5 · Medium

Failed39s · 12¢
Sheet130 cells changedWrong value

D2=C2*0.13

ABCDEF
1InvoiceVendorAmountTaxTotalStatus
2INV-001Acme Corp12500162514125Paid
3INV-002Brite Solutions840010929492Pending
4INV-003Clearview Tech9800127411074Paid
5INV-004Datasync Ltd15200197617176Approved
6INV-005Evergreen Supply76009888588Pending
7INV-006FastTrack Inc-3200-416-3616Disputed
8INV-007Global Traders11000143012430Paid
9INV-008Horizon Partners6750877.57627.5Approved
10INV-009InfoSystems13400174215142Pending
11INV-010JetPro Services#REF!#VALUE!#VALUE!Paid
12INV-011Keystone Group9200119610396Approved
13INV-012Luminary Co71009238023Paid
14INV-013Mercer Dynamics-450-58.5-508.5Disputed
15INV-014NovaTech18600241821018Pending
16INV-015Omega Supplies59007676667Approved

Why it failed: 1 cell shows an error.

Autosheet in Excel Haiku 5.5 · High

Failed24s · 0.4¢
Sheet110 cells changedWrong value

D4=C4*0.13

ABCDEF
1InvoiceVendorAmountTaxTotalStatus
2INV-001Acme Corp12500162514125Paid
3INV-002Brite Solutions840010929492Pending
4INV-003Clearview Tech9800127411074Paid
5INV-004Datasync Ltd15200197617176Approved
6INV-005Evergreen Supply76008368436Pending
7INV-006FastTrack Inc-3200-416-3616Disputed
8INV-007Global Traders11000143012430Paid
9INV-008Horizon Partners6750877.57627.5Approved
10INV-009InfoSystems13400174215142Pending
11INV-010JetPro Services#REF!#REF!#REF!Paid
12INV-011Keystone Group9200119610396Approved
13INV-012Luminary Co71009238023Paid
14INV-013Mercer Dynamics-450-58.5-508.5Disputed
15INV-014NovaTech18600241821018Pending
16INV-015Omega Supplies59007676667Approved

Why it failed: 3 cells show an error.

Autosheet in Excel GPT-6.1 Sol · Medium

Failed33s · 6¢
Sheet110 cells changedWrong value

D4=C4*13%

ABCDEF
1InvoiceVendorAmountTaxTotalStatus
2INV-001Acme Corp12500162514125Paid
3INV-002Brite Solutions840010929492Pending
4INV-003Clearview Tech9800127411074Paid
5INV-004Datasync Ltd15200197617176Approved
6INV-005Evergreen Supply76008368436Pending
7INV-006FastTrack Inc-3200-416-3616Disputed
8INV-007Global Traders11000143012430Paid
9INV-008Horizon Partners6750877.57627.5Approved
10INV-009InfoSystems13400174215142Pending
11INV-010JetPro Services#REF!#REF!#REF!Paid
12INV-011Keystone Group9200119610396Approved
13INV-012Luminary Co71009238023Paid
14INV-013Mercer Dynamics-450-58.5-508.5Disputed
15INV-014NovaTech18600241821018Pending
16INV-015Omega Supplies59007676667Approved

Why it failed: 3 cells show an error.

ChatGPT + Autosheet MCP GPT-6 · Medium

Failed1m 38s · N/A
Sheet16 cells changedWrong value

D4=C4*0.13

ABCDEF
1InvoiceVendorAmountTaxTotalStatus
2INV-001Acme Corp12500162514125Paid
3INV-002Brite Solutions840010929492Pending
4INV-003Clearview Tech9800127411074Paid
5INV-004Datasync Ltd15200197617176Approved
6INV-005Evergreen Supply76008368436Pending
7INV-006FastTrack Inc-3200#VALUE!#VALUE!Disputed
8INV-007Global Traders11000143012430Paid
9INV-008Horizon Partners6750877.57627.5Approved
10INV-009InfoSystems13400174215142Pending
11INV-010JetPro Services#REF!#REF!#REF!Paid
12INV-011Keystone Group9200119610396Approved
13INV-012Luminary Co71009238023Paid
14INV-013Mercer Dynamics-450#VALUE!#VALUE!Disputed
15INV-014NovaTech18600241821018Pending
16INV-015Omega Supplies59007676667Approved

Why it failed: 7 cells show an error. Not met: row 7: a negative amount kept, or corrected to positive, with its tax and total.

Autosheet in Sheets Haiku 5.5 · High

Failed50s · 0.6¢
Sheet132 cells changedWrong value

D2=IF(ISNUMBER(C2),C2*$I$1,"")

ABCDEFGHI
1InvoiceVendorAmountTaxTotalStatusTax rate13%
2INV-001Acme Corp12500162514125Paid
3INV-002Brite Solutions840010929492Pending
4INV-003Clearview Tech9800127411074Paid
5INV-004Datasync Ltd15200197617176Approved
6INV-005Evergreen Supply76009888588Pending
7INV-006FastTrack Inc-3200-416-3616Disputed
8INV-007Global Traders11000143012430Paid
9INV-008Horizon Partners6750877.57627.5Approved
10INV-009InfoSystems13400174215142Pending
11INV-010JetPro Services#REF!Paid
12INV-011Keystone Group9200119610396Approved
13INV-012Luminary Co71009238023Paid
14INV-013Mercer Dynamics-450-58.5-508.5Disputed
15INV-014NovaTech18600241821018Pending
16INV-015Omega Supplies59007676667Approved

Why it failed: 1 cell shows an error.

ChatGPT in Excel GPT-6 Astra · Medium

Failed52s · 95¢
Sheet113 cells changedWrong value

E4=IF(COUNT(C4:D4)=2,C4+D4,"Inputs needed")

ABCDEF
1InvoiceVendorAmountTaxTotalStatus
2INV-001Acme Corp12500162514125Paid
3INV-002Brite Solutions840010929492Pending
4INV-003Clearview Tech9800Tax neededInputs neededPaid
5INV-004Datasync Ltd15200197617176Approved
6INV-005Evergreen Supply76008368436Pending
7INV-006FastTrack Inc-3200Tax neededInputs neededDisputed
8INV-007Global Traders11000Tax neededInputs neededPaid
9INV-008Horizon Partners6750877.57627.5Approved
10INV-009InfoSystems13400174215142Pending
11INV-010JetPro ServicesAmount neededTax neededInputs neededPaid
12INV-011Keystone Group9200119610396Approved
13INV-012Luminary Co71009238023Paid
14INV-013Mercer Dynamics-450Tax neededInputs neededDisputed
15INV-014NovaTech18600Tax neededInputs neededPending
16INV-015Omega Supplies59007676667Approved

Why it failed: The broken tax cells read “Tax needed” instead of the 13% tax every other row but one uses, so their totals read “Inputs needed”.

Claude in Excel Haiku 5.5 · High

Failed40s · 1¢
Sheet130 cells changedWrong value

D2=C2*$I$1

ABCDEFGHI
1InvoiceVendorAmountTaxTotalStatusTax rate13%
2INV-001Acme Corp12500162514125Paid
3INV-002Brite Solutions840010929492Pending
4INV-003Clearview Tech9800127411074Paid
5INV-004Datasync Ltd15200197617176Approved
6INV-005Evergreen Supply76008368436Pending
7INV-006FastTrack Inc-3200-416-3616Disputed
8INV-007Global Traders11000143012430Paid
9INV-008Horizon Partners6750877.57627.5Approved
10INV-009InfoSystems13400174215142Pending
11INV-010JetPro Services#REF!#VALUE!#VALUE!Paid
12INV-011Keystone Group9200119610396Approved
13INV-012Luminary Co71009238023Paid
14INV-013Mercer Dynamics-450-58.5-508.5Disputed
15INV-014NovaTech18600241821018Pending
16INV-015Omega Supplies59007676667Approved

Why it failed: 1 cell shows an error.

Claude in Sheets Haiku 5.5 · High

Failed1m 5s · 2¢
Sheet132 cells changedWrong value

D2=C2*$I$1

ABCDEFGHI
1InvoiceVendorAmountTaxTotalStatusTax rate13.0%
2INV-001Acme Corp12500162514125Paid
3INV-002Brite Solutions840010929492Pending
4INV-003Clearview Tech9800127411074Paid
5INV-004Datasync Ltd15200197617176Approved
6INV-005Evergreen Supply76009888588Pending
7INV-006FastTrack Inc-3200-416-3616Disputed
8INV-007Global Traders11000143012430Paid
9INV-008Horizon Partners6750877.57627.5Approved
10INV-009InfoSystems13400174215142Pending
11INV-010JetPro Services#REF!#VALUE!#VALUE!Paid
12INV-011Keystone Group9200119610396Approved
13INV-012Luminary Co71009238023Paid
14INV-013Mercer Dynamics-450-58.5-508.5Disputed
15INV-014NovaTech18600241821018Pending
16INV-015Omega Supplies59007676667Approved

Why it failed: 1 cell shows an error.

Autosheet in Excel GPT-6 Luna · High

Failed49s · 1¢
Sheet112 cells changedWrong value

D4=C4*13%

ABCDEF
1InvoiceVendorAmountTaxTotalStatus
2INV-001Acme Corp12500162514125Paid
3INV-002Brite Solutions840010929492Pending
4INV-003Clearview Tech9800127411074Paid
5INV-004Datasync Ltd15200197617176Approved
6INV-005Evergreen Supply76008368436Pending
7INV-006FastTrack Inc-3200-416-3616Disputed
8INV-007Global Traders11000143012430Paid
9INV-008Horizon Partners6750877.57627.5Approved
10INV-009InfoSystems13400174215142Pending
11INV-010JetPro Services#REF!#VALUE!#VALUE!Paid
12INV-011Keystone Group9200119610396Approved
13INV-012Luminary Co71009238023Paid
14INV-013Mercer Dynamics-450-58.5-508.5Disputed
15INV-014NovaTech18600241821018Pending
16INV-015Omega Supplies59007676667Approved

Why it failed: 1 cell shows an error.

Copilot in Excel Auto

Failed1m 16s · N/A
Sheet110 cells changedWrong value

D4=C4*13%

ABCDEF
1InvoiceVendorAmountTaxTotalStatus
2INV-001Acme Corp12500162514125Paid
3INV-002Brite Solutions840010929492Pending
4INV-003Clearview Tech9800127411074Paid
5INV-004Datasync Ltd15200197617176Approved
6INV-005Evergreen Supply76008368436Pending
7INV-006FastTrack Inc-3200-416-3616Disputed
8INV-007Global Traders11000143012430Paid
9INV-008Horizon Partners6750877.57627.5Approved
10INV-009InfoSystems13400174215142Pending
11INV-010JetPro Services#REF!#REF!#REF!Paid
12INV-011Keystone Group9200119610396Approved
13INV-012Luminary Co71009238023Paid
14INV-013Mercer Dynamics-450-58.5-508.5Disputed
15INV-014NovaTech18600241821018Pending
16INV-015Omega Supplies59007676667Approved

Why it failed: 3 cells show an error.

ChatGPT + Drive MCP GPT-6 · Medium

Failed1m 8s · N/A
Sheet112 cells changedWrong value

D4=IF(ISNUMBER(C4),C4*13%,"")

ABCDEF
1InvoiceVendorAmountTaxTotalStatus
2INV-001Acme Corp12500162514125Paid
3INV-002Brite Solutions840010929492Pending
4INV-003Clearview Tech9800127411074Paid
5INV-004Datasync Ltd15200197617176Approved
6INV-005Evergreen Supply76008368436Pending
7INV-006FastTrack Inc-3200-416-3616Disputed
8INV-007Global Traders11000143012430Paid
9INV-008Horizon Partners6750877.57627.5Approved
10INV-009InfoSystems13400174215142Pending
11INV-010JetPro Services#REF!Paid
12INV-011Keystone Group9200119610396Approved
13INV-012Luminary Co71009238023Paid
14INV-013Mercer Dynamics-450-58.5-508.5Disputed
15INV-014NovaTech18600241821018Pending
16INV-015Omega Supplies59007676667Approved

Why it failed: 1 cell shows an error.

Gemini in Sheets Auto

Failed3m 25s · N/A
Sheet112 cells changedWrong value

D4=C4*0.13

ABCDEF
1InvoiceVendorAmountTaxTotalStatus
2INV-001Acme Corp12500162514125Paid
3INV-002Brite Solutions840010929492Pending
4INV-003Clearview Tech9800127411074Paid
5INV-004Datasync Ltd15200197617176Approved
6INV-005Evergreen Supply76008368436Pending
7INV-006FastTrack Inc-3200-416-3616Disputed
8INV-007Global Traders11000143012430Paid
9INV-008Horizon Partners6750877.57627.5Approved
10INV-009InfoSystems13400174215142Pending
11INV-010JetPro Services#REF!#VALUE!#VALUE!Paid
12INV-011Keystone Group9200119610396Approved
13INV-012Luminary Co71009238023Paid
14INV-013Mercer Dynamics-450-58.5-508.5Disputed
15INV-014NovaTech18600241821018Pending
16INV-015Omega Supplies59007676667Approved

Why it failed: 1 cell shows an error.

ChatGPT in Sheets GPT-6 Astra · Medium

Failed1m 6s · 73¢
Sheet16 cells changedWrong value

E4=C4+D4

ABCDEF
1InvoiceVendorAmountTaxTotalStatus
2INV-001Acme Corp12500162514125Paid
3INV-002Brite Solutions840010929492Pending
4INV-003Clearview Tech9800#REF!#VALUE!Paid
5INV-004Datasync Ltd15200197617176Approved
6INV-005Evergreen Supply76008368436Pending
7INV-006FastTrack Inc-3200#VALUE!#VALUE!Disputed
8INV-007Global Traders11000#VALUE!#VALUE!Paid
9INV-008Horizon Partners6750877.57627.5Approved
10INV-009InfoSystems13400174215142Pending
11INV-010JetPro Services#REF!#REF!#VALUE!Paid
12INV-011Keystone Group9200119610396Approved
13INV-012Luminary Co71009238023Paid
14INV-013Mercer Dynamics-450#VALUE!#VALUE!Disputed
15INV-014NovaTech18600#VALUE!#VALUE!Pending
16INV-015Omega Supplies59007676667Approved

Why it failed: 7 cells show an error. 6 cells in column D (tax) hold none of the accepted values, such as D4: "#REF!", and 2 other problems.

ChatGPT in Sheets GPT-6 Luna · High

Failed2m 7s · 1¢
Sheet113 cells changed

D4=C4*13%

ABCDEF
1InvoiceVendorAmountTaxTotalStatus
2INV-001Acme Corp12500162514125Paid
3INV-002Brite Solutions840010929492Pending
4INV-003Clearview Tech9800127411074Paid
5INV-004Datasync Ltd15200197617176Approved
6INV-005Evergreen Supply76008368436Pending
7INV-006FastTrack Inc-3200-416-3616Disputed
8INV-007Global Traders11000143012430Paid
9INV-008Horizon Partners6750877.57627.5Approved
10INV-009InfoSystems13400174215142Pending
11INV-010JetPro ServicesPaid
12INV-011Keystone Group9200119610396Approved
13INV-012Luminary Co71009238023Paid
14INV-013Mercer Dynamics-450-58.5-508.5Disputed
15INV-014NovaTech18600241821018Pending
16INV-015Omega Supplies59007676667Approved

Why it failed: C2:C16 has no validation that only accepts numbers greater than a set value.