Company Management

Discussion List

  • 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…
    1456 11
    1.5K 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.  
    726 5
    726 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…
    30 3
    Accepted Answer 30 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…
    441 8
    441 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
    19 2
    Answered - Pending Review 19 views 2 comments Most recent by Bassam Khalil 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
    18 3
    Answered - Pending Review 18 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • Charts Plotting 0
    In Using Smartsheet
    I recently contacted support to find out if there was an option within dashboard charts to keep the charts from plotting 0. I received the following response: Currently we don't have a feature in place that will prevent specific values fr…
    821 14
    821 views 14 comments Most recent by Paul Newcome Using Smartsheet
  • Master Roll-Up for multiple project sheets
    In Using Smartsheet
    I am reviewing the Construction and Facilities Management template set provided by Smartsheet.  I only have a Team account for now. The template comes with 2 sheets for Projects.  In the Master Roll-Up sheet, you can see the formulas used…
    393 2
    393 views 2 comments Most recent by Pete Bennett Using Smartsheet
  • Calculating cumulative values and reducing the total sum each day
    In Formulas and Functions
    Hi, I have a Safety Violation Sheet that uses Form Entry to record violations and assign a measured Probation Period in days. If there are multiple entries for an individual, the probation days should accumulate, at the same time the value…
    Answered - Pending Review
    141 6
    Answered - Pending Review 141 views 6 comments Most recent by Shawn Leahy Formulas and Functions
  • Auto number when box is checked
    In Formulas and Functions
    question on how to generate a number when a checkbox is checked. This seems simpler than other peoples asks, but I can't seem to make it work for me. screenshot is the area that needs to be addressed. I want the [PO #] (currently set to a…
    31 4
    Accepted Answer 31 views 4 comments Most recent by Fabrication Team Formulas and Functions