Company Management


Discussion List

  • CountIf with Date range
    In Formulas and Functions
    I am trying to count the number of requests types between a date range.  This is what I thought would work:   =COUNTIF(({Request Tracker Range 4 - Request Type}, Category5), AND({Request Tracker Range 3 - Date Requested}, DATE(2019, 01, 0…
    4771 35
    4.8K views 35 comments Most recent by Paul Newcome Formulas and Functions
  • 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…
    27 3
    Accepted Answer 27 views 3 comments Most recent by Genevieve P. Using Smartsheet
  • Seeking consultants
    In API & Developers
    We're an organisation responsible for government facilities management, asset management and projects . We currently use Smartsheets but require refined and custom built business solutions to assist in business operations. We're seeking ex…
    Answered - Pending Review
    17 3
    Answered - Pending Review 17 views 3 comments Most recent by Darren Mullen API & Developers
  • 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…
    1246 11
    1.2K views 11 comments Most recent by Genevieve P. Formulas and Functions
  • Automated Workflows Limit
    In Using Smartsheet
    Hi  Is there any limit to how many "automated workflows" we can create in a single sheet? Asking because one of my projects is expected to have approx 30 automated workflows in it.  
    571 5
    571 views 5 comments Most recent by Leslie Merlino Using Smartsheet
  • SumIf
    In Formulas and Functions
    I am trying to use the SUMIF Formula to reference a sheet to add hours based on the name of an employee. I have a Names Column with a list of names and an Hours Column. On a second sheet I am trying to print out their hours added together…
    20 3
    Accepted Answer 20 views 3 comments Most recent by Andrée Starå Formulas and Functions
  • Example of Advanced Smartsheet Reporting & Interconnectivity
    In Using Smartsheet
    Hello, I have built a series of Smartsheet that collects data from 8 different sources and combines it into one easily accessible Dashboard that is interlinked with other Dashboards. We use forms to collect responses and store them in 6 D…
    370 8
    370 views 8 comments Most recent by Samuel Courtney Using Smartsheet
  • Avoid Overbooking a Training Resource
    In Using Smartsheet
    Hello, I'm looking for others who are using Smartsheet to manage their company's learning and development department. I manage a small training team that currently uses Smartsheet to schedule training. I am looking for a solution that w…
    Answered - Pending Review
    14 2
    Answered - Pending Review 14 views 2 comments Most recent by Bassam Khalil Using Smartsheet
  • % Allocation
    In Using Smartsheet
    As a new user, I found that the % Allocation column does not respond to input from the Duration column, as seems intuitive to me. After reviewing community comments, I find that the % Allocation functionality in Smartsheet does not actual…
    EdL Profile Photo EdL
    1598 8
    1.6K views 8 comments Most recent by Sylvain Martel Using Smartsheet
  • Sheet Overview/Screenshot in Dashboards
    In Using Smartsheet
    Hello, I'd like to create a dashboard for my team where we can see information from multiple sheets at once. These are normal grid sheets, not reports. Is there a way to do this using the dashboard feature? Appreciate any guidance. Thank y…
    Answered - Pending Review
    12 3
    Answered - Pending Review 12 views 3 comments Most recent by Andrée Starå Using Smartsheet