Other

 

Discussion List

  • Looking for most recent date
    In Formulas and Functions
    I 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 …
    Accepted
    749 8
    Answered ✓ 749 views 8 comments Most recent by Valerie_WPA Formulas and Functions
  • Numerical "Priority" Method
    In Formulas and Functions
    Hello, 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 …
    Accepted
    10 3
    Answered ✓ 10 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • Formula to find the average word used in a column
    In Formulas and Functions
    Hi, 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
    Accepted
    78 13
    Answered ✓ 78 views 13 comments Most recent by Genevieve P. Formulas and Functions
  • Column isn't an option to filter by
    In Using Smartsheet
    fairly 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…
    Answered - Pending Review
    13 2
    Answered - Pending Review 13 views 2 comments Most recent by Andrée Starå Using Smartsheet
  • Calculated parent % complete issue
    In Formulas and Functions
    Hello - 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…
    Accepted
    53 4
    Answered ✓ 53 views 4 comments Most recent by JAM_BFT Formulas and Functions
  • Remove Primary Column From Report
    In Using Smartsheet
    I 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!  
    1581 10
    1.6K views 10 comments Most recent by Genevieve P. Using Smartsheet
  • Freeze Column issue
    In Using Smartsheet
    Good 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…
    Answered - Pending Review
    28 4
    Answered - Pending Review 28 views 4 comments Most recent by Loann McGee Using Smartsheet
  • Workflow for Tracking Inventory Counts and Bin Locations
    In Formulas and Functions
    Hi, 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…
    Accepted
    24 7
    Answered ✓ 24 views 7 comments Most recent by Jeff Reisman Formulas and Functions
  • How do I hide the sidebar/shared with bar?
    In Using Smartsheet
    Is 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.
    Answered - Pending Review
    307 8
    Answered - Pending Review 307 views 8 comments Most recent by Lina M Using Smartsheet
  • How do I get a sum for each location (Room 600-605) excluding expired materials?
    In Formulas and Functions
    In 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"…
    Accepted
    27 3
    Answered ✓ 27 views 3 comments Most recent by Jon Mark H Formulas and Functions