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…
    3654 33
    3.7K views 33 comments Most recent by Paul Newcome Formulas and Functions
  • 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…
    5261 28
    5.3K views 28 comments Most recent by Paul Newcome Formulas and Functions
  • Smartsheet Company Wide Training
    In Using Smartsheet
    I am trying to find any training material that Smartsheet has that I can leverage for company wide training. I will be organizing our training/implementation/roll out plan to ensure all necessary employees understand the tool and can hit k…
    Answered - Pending Review
    12 1
    Answered - Pending Review 12 views 1 comment Most recent by Jen Lange Using Smartsheet
  • Smartsheet not saving consistently
    In Using Smartsheet
    I have multiple Smartsheets this has happened to, although I save and make sure prior to closing the SS it has been saved, and triple-check by the "save" icon being "shaded" prior to closing the SS. From time to time wh…
    703 11
    703 views 11 comments Most recent by Andrée Starå Using Smartsheet
  • 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
    17570 36
    Accepted Answer 17.6K views 36 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…
    3235 23
    3.2K views 23 comments Most recent by JeremiahHorstick API & Developers
  • 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…
    478 12
    478 views 12 comments Most recent by Paul Newcome Using Smartsheet
  • Tracking Employee Training and Certifications
    In Using Smartsheet
    Hello! We are trying to find the best way to track employee training and certifications categorized by department and type of position. Has anyone been working on anything similar that they could share? TiA!
    Accepted
    500 4
    Accepted Answer 500 views 4 comments Most recent by Andrée Starå Using Smartsheet
  • Automatic Children Indenting
    In Using Smartsheet
    Hello,   Is it possible to set up a formula for information (if it is the exact same as the parent/child row above) that you have underneath a child/parent row to automatically attach itself inside the Parent/Child Hierarchy? I would rat…
    864 16
    864 views 16 comments Most recent by jg124 Using Smartsheet
  • Bubble Chart?
    In Using Smartsheet
    Hi all -- I am new. Trying to get a bubble chart template that I can use to make a gorgeous bubble chart. No results when I start a new sheet and type in "bubble chart."  Ideas? Help? Thanks very very much -- Andrea
    220 5
    220 views 5 comments Most recent by Ivonne Mejia Using Smartsheet