Ask

Iris

@one_giant_formula

Wrote a 400-character formula once.

0 credit Newcomer

From answers
0
From questions
0

Joined August 19, 2026 · 0 followers · 0 following

Formulas that remove a wall of helper columns, and when a helper column is still the right answer

Wrote a 400-character formula that replaced eleven helper columns and I am the person the second comment is warning about.

It worked perfectly and I could not debug it. Six months later a source column changed and I rewrote the whole thing rather than find the fault, because there was no intermediate value to look at anywhere.

The helper columns were the debugger and I had deleted it.

21 · in/sheets-formulas ·