Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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?
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.
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
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.
Craig
