Company Management

Discussion List

  • Track inventory movement in multiple warehouse locations
    In Formulas and Functions
    Hi, We would like to track inventory movement between multiple warehouse locations, there is no need to track stock value/sales, just need to track inventory movement between locations and the inventory balance Warehouse: Warehouse A, War…
    Answered - Pending Review
    36 2
    Answered - Pending Review 36 views 2 comments Most recent by Ashley356 Formulas and Functions
  • Can you add an approval or action button directly to a notification?
    In Using Smartsheet
    Hello - I am new to Actions and Alerts.  I would like to set up a workflow to allow our team to submit travel requests for their managers for approval.  I have my form and sheet set up fine, and the workflow seems to be working correctly a…
    228 4
    228 views 4 comments Most recent by Retail Experience Using Smartsheet
  • Count number of times a value appears?
    In Using Smartsheet
    I have a sheet for tracking the amount of defects that occur. Each defect report has a "Machine Name" value which is selected via a dropdown. What I'm trying to achieve is to have a counter, in any form but preferably a widget or…
    Accepted
    23 9
    Accepted Answer 23 views 9 comments Most recent by Andrée Starå Using Smartsheet
  • Tracking Template Usage Weekly
    In Using Smartsheet
    Hi, I have a set of mandatory templates/sheets within smartsheets that need to be filled in weekly by my team. I have a date cell recording when the sheet was last edited and who is responsible for filling the sheet in and am looking to cr…
    Answered - Pending Review
    13 1
    Answered - Pending Review 13 views 1 comment Most recent by GrahamWelsby 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…
    8868 43
    8.9K views 43 comments Most recent by Paul Newcome Formulas and Functions
  • Include Multiple Recipients on Single Email Alert
    In Using Smartsheet
    We are currently using a form to track internal requests.  We are trying to get smartsheet to send an email to multiple recipients on a single email thread.  Essentially using this form to generate an email thread which has all of the foll…
    175 2
    175 views 2 comments Most recent by neilltm Using Smartsheet
  • Vacation & Time-Off Management
    In Using Smartsheet
    Has anyone used smartsheet to manage time-off requests and/or vacation for a pool of staff (approx. 200)?  
    3035 15
    3K views 15 comments Most recent by Genevieve P. Using Smartsheet
  • 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…
    5872 40
    5.9K views 40 comments Most recent by Akellu Formulas and Functions
  • 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…
    1497 21
    1.5K views 21 comments Most recent by Paul Newcome Using Smartsheet
  • % 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
    1893 9
    1.9K views 9 comments Most recent by Alon Dagan Using Smartsheet