Discussion List

  • Rows will not stay in place. NEED HELP NOW
    In Using Smartsheet
    We use a sheet as both a schedule and data collection tool as part of a much larger system we just put in place (literally 5 days ago, moved from google sheets). The information is organized manually first by employee and second by the pri…
    507 15
    507 views 15 comments Most recent by BrittColby Using Smartsheet
  • Need Help with Formula for Rolling Metrics
    In Formulas and Functions
    I am working on a 6 months rolling metrics calculation for a point system. A simple data involved will be as follows: 1) Date column 2) Points column (0-10) 3) Name column   I need to calculate a 6 months rolling sum of points, for e…
    606 10
    606 views 10 comments Most recent by Tyrone T Formulas and Functions
  • Relating sheets many to many
    In Using Smartsheet
    Hi there. I am trying to design a set of sheets in Smartsheet to allow two different types of projects to be related to one another. I have species projects in one sheet and site projects in another sheet. I want to relate these two she…
    Answered - Pending Review
    25 3
    Answered - Pending Review 25 views 3 comments Most recent by L_123 Using Smartsheet
  • Nonprofit looking for assistance expanding template set
    In Using Smartsheet
    Hello All, I'm in Operations at a nonprofit. I am hoping for assistance in building out the Template Set for Objective and Key Results (OKR) Tracker. The template set is built for 5 objective. I need it built out for 12 and I am running…
    30 2
    Accepted Answer 30 views 2 comments Most recent by Andrée Starå Using Smartsheet
  • Bulk Removal of Users
    In Using Smartsheet
    Hello, Just wanting to check if there's a way of bulk removing of Smartsheet users? I know you can bulk upload contacts/users into Smartsheet but need to know if you can do the same by removing. The reason for this is to avoid a long wind…
    34 3
    Accepted Answer 34 views 3 comments Most recent by Genevieve P. Using Smartsheet
  • COUNTIF Formula for Contact Column
    In Formulas and Functions
    I have several tasks set up for team members using their email addresses in the Contact column. Some tasks have 1 member assigned and some have multiple. I have to run each person's workload and am trying to use a separate sheet that count…
    1318 11
    1.3K views 11 comments Most recent by Genevieve P. Formulas and Functions
  • Smartsheet University Is Here!
    In General Announcements
    Hi Community,  We are excited to introduce Smartsheet University, a single platform for eLearning, live instructor-led training, in-person training, and custom training. Smartsheet University offers unique learning paths and meaningful con…
    432 7
    432 views 7 comments Most recent by John Ramirez General Announcements
  • Formula for percent match to a multi select column
    In Formulas and Functions
    Hi, I'm working matching mentors and mentees.  We would like to match them based on attributes they both selected in a multi select column.  As in, choose your top three competencies.  Now I would like to make a formula to determine the pe…
    128 9
    128 views 9 comments Most recent by Pam Ferguson Formulas and Functions
  • Task duration based on allocation
    In Using Smartsheet
    I'm using resource allocation to calculate schedule duration but the schedule isn't updating to reflect the allocation. Why didn't resource allocation (other than 100%) change task duration?
    159 3
    159 views 3 comments Most recent by Sylvain Martel Using Smartsheet
  • Timeline end date not updating correctly - help needed
    In Using Smartsheet
    Hi, I'm having an issue with my end date at the top not updating correctly. I have all the subtasks below indented correctly; however, it will not reflect that at the top most level. Please see the photo attached. I added in a new line at …
    Answered - Pending Review
    21 4
    Answered - Pending Review 21 views 4 comments Most recent by Andrée Starå Using Smartsheet