Posted 27 April 2020, 10:48 pm EST - Updated 30 September 2022, 4:33 am EST
When Editing a Cell Formula that is a large formula the cell where the formula is located displays the entire formula so it bleeds over into all the cell needed to display that formula.
When this happens trying to evaluate how the formulas results are determined becomes impossible in many cases because the values, if on the same row, are no longer visible and if you were editing and trying to click on cells to include them as part of the formula you can’t because it is blocked by the displayed formula.
Attached is a sample image from our demo data showing the issue.
Is there a way to have the cell not display the entire formula when using the formula Text box for editing the cell formula.
Thanks,
Kevin