Company Management

 

Discussion List

  • Formula to count of items in a multi dropdown list
    In Formulas and Functions
    Hi The drop-down multi select is very nice and useful.  I started to use it yesterday, but I need to use the formula =countif(range, criterion).  I want to count how many times a value is repeated in a range that has multi values. I use …
    Accepted
    23264 42
    Accepted Answer 23.3K views 42 comments Most recent by Paul Newcome Formulas and Functions
  • Format as time
    In Using Smartsheet
    I need to keep accurate documentation of how long my deliveries take (down to the minute) I normally do this in spreadsheets by having the column formatted as a time. I cannot see that option in the formatting list. Am I blind or is it not…
    71 4
    71 views 4 comments Most recent by Sheryl Roland Using Smartsheet
  • COUNTIFS/CONTAINS FUNCTION
    In Formulas and Functions
    Hi All,  I need help with a formula to Count every instance a name appears in a multi-select row of a column based on criteria from another column first. At present this is my first formula: =COUNTIFS({CORP ADMIN TEAM TASKS Range 1}, &qu…
    7646 41
    7.6K views 41 comments Most recent by Paul Newcome Formulas and Functions
  • Quickbooks & Smartsheet
    In API & Developers
    So. I've been working on this Quickbooks & Smartsheet Integration for a couple of years now for my own internal use.  It has many application & the proof of concept exists and we use it.  We use it for an approval process (for in…
    4208 30
    4.2K views 30 comments Most recent by JeremiahHorstick API & Developers
  • 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…
    5034 35
    5K 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…
    Accepted
    32 3
    Accepted Answer 32 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
    26 3
    Answered - Pending Review 26 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…
    1297 11
    1.3K 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.  
    608 5
    608 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…
    Accepted
    21 3
    Accepted Answer 21 views 3 comments Most recent by Andrée Starå Formulas and Functions