The inline formula editing is nice but is limited as which you have a few lines it becomes unusable - maybe just my long/bad formulas but is becoming a right PITA

# Larger / Separate formula window

@Phil_White Iâ€™ve encountered this one or two with monster formulas. Iâ€™d recommend unrolling your formulas into multiple columns. This also improves performance: if you have multiple columns performing similar calculations (e.g. the same filter except for one), it reduces the number/size of recalculations youâ€™ll have to do.

**cnr**#3

Yeah, this is vital. Especially, if there could be some way to introduce intermediate values rather than building one enormous formula.

Obviously, you could create a Section with multiple smaller chunks of the formula, and then just look up the result from there, but it seems like there is a benefit to having the formula right there in the sheet youâ€™re working on, and having all the preceding formulas readable at once.

I would like an inverse formula tool, where I could see what the intermediate values of my formula is at every step along the way.