It is not always possible, of course. But it normally is. For the edge cases a helper like this must be nice. Maybe some fields have lots of edge cases, mine has few.
Either make it a video so you can pause it or just have static screenshots without animation.
leobg•1h ago
I often have this problem in Google Sheets. So far, i’ve resorted to copying the formula into Sublime Text and then splitting it into multiple lines. Your editor looks much more intuitive.
As demo, it would be nice if one could press a button to load some real data abd formulas. I’m reading HN on my phone. I guess many people do. Coming up with a formula and example data is an extra hurdle, and doing it using just a thumb and dumb autocorrect doubly so.
I did see the screenshots on GitHub. Thumbs up for those!
bthallplz•1h ago
tcho•52m ago
> 1. You can drag down the bottom of the formula bar/field and make it multi-line.
> 2. You can insert arbitrary newlines in an Excel formula.
> For example:
I learned this from this comment from last week: https://news.ycombinator.com/item?id=46341227knollimar•21m ago
=Let(table,$C$17:$S$24,
rowName,A6,
colName,C6,
headerRow,$C$15:$S$15,
headerCol,$A$17:$A$24,
rowIndex,MATCH(rowName,headerCol,0),
colIndex,MATCH(colName,headerRow,0),
index(table,rowIndex,colIndex)
)
or even
=LAMBDA(table,rowNames,colNames,rowToFind,colToFind,
)($C$17:$S$24,$A$17:$A$24,$C$15:$S$15,A6,C6)(Also alt+enter to input the newlines)