Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Display of a formula under/above row

Krzysztof Żebruń
Krzysztof Żebruń ✭
edited 12/09/19 in Archived 2017 Posts

Hello

 

In some sheets i have long formulas to grab many intermediate values and eg. sum them in one cell. Problem is when I need to click a cell and this is hidden by formula. Can the formula be displayed under/above a row where I'm typing?

2017-05-02 08_39_12-Wyceny-kalkulacja - Smartsheet.com_.png

Tags:
· Share on FacebookShare on Twitter

Comments

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    This has been a nuisance to me as well. I get around it by scrolling slightly with my mouse wheel - or the side scrollbar...while I am working in the pop-up window. It tends to reveal what  I need. 

    · Share on FacebookShare on Twitter
  • Brad Jones
    Brad Jones ✭✭✭✭✭✭

    Right on man!  This has been a pain for me for a while.  The workaround was easy enough (press the escape key and then click where I need to), but why not put the formula out of the way?

    Another option, put it into a little bar at the top of the browser window.  Then it's not in the way of ANYTHING :)

    · Share on FacebookShare on Twitter
  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    My work-around is to select the cell below the one I want and then change the row number manually.

    This is also a thorn I would be grateful to see removed.

    It would be worse if, you know, I wrote formulas often. angel

    Craig

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories