Wait, that’s an actual formula. When I first saw this I thought it was an employee going insane and keysmashing into a spreadsheet as evidenced by the “send help”.
Yup, actual formula. Might not even be the most offensive one in the spreadsheet.
Wait till AI is able to help.
=TEXTJOIN("",TRUE,A330,A443,A556,A669,A782,A895,A1008,A1121,A1234,A1347,A1460,A1573,A1686,A1799,A2112,A2225,A2338,A2451,A2564,A2677,A2790,A3303,A3316,A3329,A3342,A3355,A3368,A3381,A3394,A5407,A5420,A5433,A5446,A5459,A5472,A5485,A5498,A5511,A5524,A5537,A5550,A5563,A5576,A5589,A5602,A5615,A5628,A5641,A5654,A5667)OMG. Which AI tool produced this?
Claude. To be fair, it had trouble OCR-ing it. After way too much back and forth about the pattern, it produced this:
=LET( rows, SEQUENCE(INT((667-30)/13+1),1,30,13), SUM(INDEX(AA:AA,rows)) )Which is correct, but obviously the calculations would be best served by reorganizing the table and probably using a pivot table or at least grouping and subtotaling.
I must find the monstrous function which indexes virtual arrays that I implemented in a Google sheet of mine when I discovered there’s no limit to how reckless you can be in a single cell.
Edit: Here it is:
ARRAYFORMULA(IFERROR((INDEX('Invoice History'!$A$7:$A$44, SMALL(IF(($G$3='Invoice History'!$D$7:$D$44)*('Invoice History'!$F$7:$F$44="Unpaid"), MATCH(ROW('Invoice History'!$A$7:$A$44), ROW('Invoice History'!$A$7:$A$44)), ""), ROW(A1))))))According to my documentation, it is used for “Looking up a value on a row, on another sheet, where two other values on that row match the given criteria”
