-
How do I report cost changes?
Hello, I am trying to create a chart that shows the financial impact on a community when a change is made. Here's the backstory - I am in homebuilding and any time there is a change at a community, we associate that change with a CRF #. I would like to be able to create something that shows the change in dollar amounts per…
-
#BLOCKED Error with COUNTIFS when Range columns are populated via equations
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…
-
Clean up formula building experience
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…
-
When I double click a column header to change the name
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?
-
Formula cell limit
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?
-
Splitting Single Sheet Horizontally to have two separate scroll bars
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!
-
Where is my undeleted sheet?
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
-
Can multiple users use the same sheet without causing changes for other users?
Sorry if my question is unclear. Here's what I'm getting at: I have an onboarding training checklist I made for all new hires. Each new hire has their own individual dashboard. Basically, I want to add the general onboarding checklist (which is a sheet) to each employee's dashboard. However, I want to know if there is a…
-
500000 cells, what is you need more
Hi, what can you do when you need more than 500000 cells?
-
Filter Not Working in Card View on a Sheet
Hi - My company has a sheet of tasks for employees and it looks like one of the filters isn't working correctly. When Filtered, The All Staff filter has filtered out one person, "Sam the Butcher". I clicked on the drop-down menu and verified that he's the only person filtered out. This is the end of any reference to "Sam…
