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
    18897 37
    Accepted Answer 18.9K views 37 comments Most recent by Allison Huerta Formulas and Functions
  • % 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
    1348 7
    1.3K views 7 comments Most recent by Ray B 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…
    5785 35
    5.8K views 35 comments Most recent by Paul Newcome Formulas and Functions
  • Has anyone mapped their Smartsheet files using the API?
    In API & Developers
    2 part question here. My company is currently looking at ways to map how all of our sheets link to one another in a consolidated database. A thought that came to mind is using the Smartsheet API to access all of the underlying data (sheet …
    Accepted
    22 3
    Accepted Answer 22 views 3 comments Most recent by BKing API & Developers
  • Automatically Track Inventory Usage
    In Formulas and Functions
    I'm new to smartsheets and am not an excel expert, but I've been building some sheets and workflows and have a question about more advanced capabilities of the program.  I'm hoping there's a way to automatically track inventory usage base…
    474 7
    474 views 7 comments Most recent by Alexander Coales Formulas and Functions
  • Trying to Auto-update due dates based on actual completion date
    In Using Smartsheet
    Hi,  I am new to smartsheet and I am finding it very useful; except that I can't figure out how to auto-update completion dates.   For example, when I plan out my project, I put start dates, duration, predecessors and who it's assigned …
    495 6
    495 views 6 comments Most recent by Paul Newcome Using Smartsheet
  • Auto fill a second column based on a drop down selection using a form
    In Formulas and Functions
    I understand I can likely do this with a very, very long VLOOKUP  or IF/THEN formula in every cell, but I'm dealing with over a hundred items and that will be unwieldy.  Situation: I would like to have a form where someone selects one op…
    6274 20
    6.3K views 20 comments Most recent by Ashlyn Melvin 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…
    3951 33
    4K views 33 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
    11 1
    Answered - Pending Review 11 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…
    743 11
    743 views 11 comments Most recent by Andrée Starå Using Smartsheet