Other
Discussion List
-
Looking for most recent dateIn Formulas and FunctionsI have two sheets. The first is a tracker for up coming reoccurring tasks and the second is a copy of rows that have been completed. In the first sheet I would like to collect the date from the "date" column in the second sheet …
-
Numerical "Priority" MethodIn Formulas and FunctionsHello, I am in need of a method for assigning priority of a submitted row 1-10. If 1 is selected, the previous 1 needs to become a 2, the 2 becomes a 3, etc. The column needs to recalculate when a row is complete and the 'priority' column …
-
Formula to find the average word used in a columnIn Formulas and FunctionsHi, Is there a formula I can use to find the average "word" used in a column? For example, I want to find the average of these words from the drop-down list: Cheers! Ann
-
Column isn't an option to filter byIn Using Smartsheetfairly new to smartsheets, why aren't all columns available on the list when making a filter? I did not build this smartsheet but am the owner now so I am not sure if it's something on the backend I may not know yet. I need to create a fi…
-
Calculated parent % complete issueIn Formulas and FunctionsHello - We are using one of the templates to track a project. We track % complete at the lowest level and then use the parent rolled up % complete. We are seeing a very strange error in the parent % complete. I have attached a few examples…
-
Remove Primary Column From ReportIn Using SmartsheetI am running a report from my sheet however the primary column shows up even though I did not select it and I cannot hide it. I don't want/need it in my report. I was wondering if there was a way to remove or prevent it. Thanks!
-
Freeze Column issueIn Using SmartsheetGood afternoon, We have a Freeze set to maintain the view of a certain columns that are referred to throughout the day. However, the freeze doesn't actually work as expected, as almost every time I go into our sheet the pane has been moved…
-
Workflow for Tracking Inventory Counts and Bin LocationsIn Formulas and FunctionsHi, I am trying to setup a sheet to keep track of when we count bin locations in our warehouse and how often. I would like every bin to be counted at least once ever 12 weeks. In our bin locations column, I have a multi-checkbox setup with…
-
How do I hide the sidebar/shared with bar?In Using SmartsheetIs there anyway to hide the left sidebar or workspace shared to bar in this new update? I can't see the names of anything unless I zoom out from the entire window.
-
How do I get a sum for each location (Room 600-605) excluding expired materials?In Formulas and FunctionsIn this first image the "Complete Count QTY" column sums the materials excluding expired materials. This works perfectly. In this image you can see my attempt at getting a sum for Room 605 in the "Location Specific QTY"…