I have looked at multiple questions and threads on the community and not found an answer that works. I am trying to create a column formula that pulls the [Balance] from the previous row into the current row entry. I was getting a #circular reference error, I tried IFERROR and some recommendations on other posts, but…
Hello I have 2 sheets a master sheet and a sheet that is populated from a form. the first few columns on the master sheet are filled in via form, that data is then used for estimation which is filled into the second form. the data from the first form is added to the data from the second form on the second sheet using…
It would be very useful to lock a single cell. I see it's been asked many times on the community but I did not find anyone submitted it as an idea
I frequently use the "favorites" star on the left to quickly go to my sheets. I have had some trouble quickly accessing the sheets because I scan with my mouse up and down the list. Each sheet creates a pop-up when you hover over it. This makes it difficult because I end up clicking the pop-up instead of the sheet I…
I have a consultant, who does not have a license, who I gave Sheet permissions 'Editor-Can Share'. They attempted to share the Sheet and received an error message saying that they do not have "sufficient permission to modify sharing on this item". As far as I can see they have permissions, so I don't know why they are…
Hi, I've created a new sheet and a form, I've applied text wrap to the columns that might need it and I've tested certain cells, inputting more text than the cell than would be visible. I've clicked an unclicked the text wrap button on the menu... nothing is happening. I've saved and refreshed the sheet...still no text…
While it is wonderful that we now have the ability for custom colors on Dashboards, it would be truly helpful to also have this same ability in Sheets. It would be really helpful for some of our projects because our district uses certain colors to call attention to various district initiatives or our district instructional…
My team manages many projects, each having a sheet with many parent and child tasks. I am researching ways to roll project data up into overall portfolio views for leadership but all of the PPM/PPO templates Smartsheet provides seem to pull portfolio data from an "intake sheet" which is not a process we employ. I'm finding…
Similar to how rows can be indent or outdented and then collapsed/expanded I would like to see a similar feature for columns. i know I can hide columns but this would be different because It would be collapsed under a section.
