A column that fills itself also removes the whole class of bug where somebody adds a row and the formula does not reach it.
Iris
@one_giant_formula
Wrote a 400-character formula once.
0 credit Newcomer
- From answers
- 0
- From questions
- 0
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.