f(x) & Edit Reference do not appear

The help documentation states the following about cell references: “You can edit the name, referenced cell range, and source sheet of the reference.”

If using a long formula and selecting the cell containing the formula, the left-most portion of the formula is not visible on the display (i.e., f(x) = AND Edit Reference do not appear. Therefore, I am unable to click on any references to bring up the Reference Another Sheet form in order to rename them or simply see what range is being used. A vertical scroll bar is presented which allows up/down movement, but no horizontal scroll bar to allow left/right movement.

What am I overlooking? Is there another way? I have Admin permission to all sheets.

Thank you,

Dan

Find more posts tagged with

Formulas

Cell linking

Comments

Paul Newcome

Could it be a "Zoom" setting on your browser itself instead of within smartsheet? I've personally never had that issue. The formula will stretch from one side of the screen to the other and keep adding rows, but the "Help Box" and the formula in it's entirety will stay on the screen. I even tried using the bottom horizontal scroll bar to see if maybe that was it, but no matter where I was on the page, the formula and "Help Box" stayed front and center.

Dan Seidler

We tried zoom, but it did not help. Ours will not add rows - it is one, VERY long formula.

Paul Newcome

You may want to contact Smartsheet support directly about that. It doesn't seem like it should be working that way.

Even when I have entered formulas (accidentally) exceeding the 4,000 character limit, the formula box does more of a "wrap text" for me. (It just crashes when you try to save. No heads up, no warning, not even a reason for the crash. It just crashes... )

Sign in to join the conversation!

Quick Links

Trending discussions

Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
Countifs result not matching filter
In my sheet, I have a filter for 2 values (see below images). The result is 294 In my report this formula yields 304. =COUNTIFS({helper-child}, "1", {gapStatus}, <>"Rejected (not a GAP)", {gapStatus}, <>"removed - duplicate", {gapStatus}, <>"removed - not valid") Why are they not matching? What am I missing?
Using CONTAINS in a MAX(COLLECT) function
I have a schedule that has a task name column, a date column and a task type column. I am trying to build a formula (in another sheet) that will return the latest date based on when the task type is "APP" and the task name contains "GS" somewhere in the cell. Here is the formula I have come up with: MAX(COLLECT({Schedule…