Hi, I am trying to calculate the amount of "Used Inventory" by counting the number of times "Block Date" appears between "DATE 1" and "DATE 9" but am getting the #BLOCKED error. Columns "DATE 1" through "DATE 9" are populated by equations based on "CheckIn Date" and "CheckOut Date." Below, you can see the columns in use…
I would LOVE to see a significant enhancement to the experience of building formulas. Formulas are the single most common area of confusion, and the first "step" of any builder toward enabling automation and leveraging Smartsheet. Therefore, the formula builder could use some help to take it from "just as bad as excel, all…
The Contact List, Dropdown (Single Select), and Dropdown (Multi Select), are useful tools to control data entry. The problem is they require a lot of maintenance. Through Bridges, we have a sheet that is populated with information from our ADP. It contains all of our employees. Using a Contact List column and selecting the…
When I double click a column header to change the name, a pop up shows up telling me to double click the header to change the name. Not only have I just done the action, the pop up prevents me from then seeing what I'm changing the header name to! Is this only happening to me or is this a design flaw that needs to be fixed?
Help! I hit the 25000 cell limit when doing formulas .is there a work around or a way to get limit lifted with business license?
Hello, We have a request form that needs to be split horizontally to allow for two different categories of jobs. Excel does this pretty easily, but I don't see a way to split a sheet horizontally. Creating a report or dashboard will not work in this instance. Thank you!
Hi, I accidentally deleted a sheet. I browsed to the deleted folder and selected "undelete". Now the sheet is gone from the delete folder and nowhere to be found. It has been ten minutes. How long does it take to undelete, and can someone help me restore it? Thank you Rad
merge data into cells like excel does in a user friendly way similar to this article. https://www.projectwidgets.com/how-to-merge-cells-in-smartsheet/
Include the column description when an update request goes out to provide some context to the column if it has a generic name.
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