1

picture of offending boxThe extra formula box that pops up on google sheets is easily one of the dumbest and most annoying features I have encountered while using google sheets and I am surprised nobody else seems to talk about it. Am I missing something it constantly has me scrolling to look behind it to see the information on the sheet I am writing a formula for. Does anyone actually use this feature and if so why? I cant find a way to disable it.

1
  • While an image might be helpful, sample data and formulas should be included as text. Also questions about spreadsheet formulas should describe the relevant parts of the spreadsheet including spreadsheet settings like the spreadsheet locale as it affects the function parameter separator among other things. Jun 3, 2023 at 20:56

1 Answer 1

0

You are not missing anything. There are many people using the formula box. There is no way to disable the formula box in Google Sheets.

It is a matter of taste whether a user prefers the formula box or the formula bar at the top. Both are standard features in spreadsheet programs.

The logic in the formula you show in the screenshot seems unnecessarily complex. There would probably be a way to rewrite it in a much less convoluted way so that it fits on perhaps three short lines, which would make the box less trouble.

2
  • Please illuminate I am always looking to simplify and am completely self taught.
    – XCATHADOR
    Sep 6, 2022 at 9:21
  • Please ask only one question per post. If you choose to post another question, consider sharing a publicly editable sample spreadsheet with realistic-looking data, and showing your manually entered desired results there. Sep 6, 2022 at 10:01

Not the answer you're looking for? Browse other questions tagged or ask your own question.