-
Pause Time Tracked
I have a request to create a way to track a certain record's time since it's been opened, but the user would like the tracked time to not include when it's in a certain status. For example, if the record is in "Open" status for 2 hours, have 2 hours tracked. If the same record is changed to "Waiting on feedback", however…
-
#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…
-
Dynamic dropdowns - Waterfall request
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
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?
-
Deleting or Deactivating Request emails
Hello, I have an automation where it send a request email automatically and it resends the same email 2 more times both request emails. I do it this way as a reminder and don't have to ask them to search their emails. Is there a way to automatically delete or deactivate the old request emails? I know I can manually do it…
-
Calculation from Sheet with shuttled Data to combined data
I have a sheet that is refreshed every morning to add and update existing data from an in-house data warehouse. I am trying to create a sheet that pulls from the original sheet and can produce a graph in dashboard that tells me how long something has been in a current state, with many things being in that state for various…
-
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?
-
Freeze Row
Enhancement request to add capability to freeze row (like freeze column)
-
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!