Company Management

Discussion List

  • 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…
    654 10
    654 views 10 comments Most recent by Constantin Hapau 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
    16669 36
    Accepted Answer 16.7K views 36 comments Most recent by Paul Newcome Formulas and Functions
  • 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…
    3404 31
    3.4K views 31 comments Most recent by Tabitha W. 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…
    3078 23
    3.1K 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…
    441 12
    441 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
    455 4
    Accepted Answer 455 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…
    819 16
    819 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
    208 5
    208 views 5 comments Most recent by Ivonne Mejia 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…
    4841 26
    4.8K views 26 comments Most recent by Paul Newcome Formulas and Functions
  • Mindmap / Spider Web views of parent/child and relationship dependencies across worksheets
    In Using Smartsheet
    Hi Has anyone looked at or know of a way to create a more interactive dashboard of a mindmap / spider view of worksheet relationships and parent child dependencies within? I am using smartsheet to manage organisational OKR's and whilst I c…
    Answered - Pending Review
    44 3
    Answered - Pending Review 44 views 3 comments Most recent by Graham Ledger Using Smartsheet