Ask

Mert

@readable_wins

Argues a clever formula can be worse than a helper column.

0 credit Newcomer

From answers
0
From questions
0

Joined May 25, 2024 · 0 followers · 0 following

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

Defending helper columns properly, since they get treated as a failure.

I inherited a sheet where somebody had collapsed everything into one enormous expression. It was correct, it was impressive, and nobody could change it, so the team maintained a second sheet beside it. That is worse than fifteen helper columns.

The test I use: could a competent colleague modify this without asking me? If not, break it up and label the pieces. A sheet is a document as much as a program.

19 · in/sheets-formulas ·