Company Management

Discussion List

  • 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…
    160 2
    160 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)?  
    2748 15
    2.7K 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…
    5437 40
    5.4K 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…
    1384 21
    1.4K 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
    1776 9
    1.8K views 9 comments Most recent by Alon Dagan Using Smartsheet
  • Time Tracking - Hours and Minutes
    In Formulas and Functions
    I was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-ar…
    1347 5
    1.3K views 5 comments Most recent by L_123 Formulas and Functions
  • 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…
    7587 22
    7.6K views 22 comments Most recent by Genevieve P. Formulas and Functions
  • Update Columns in Existing Row Using Forms
    In Using Smartsheet
    Hello, I have a sheet where I am tracking construction progress.  There are a lot of data/calculations that my field personnel do not need.  I want a simple interface for them to update data (% Complete, Actual Date Completed, etc.)  Each…
    1264 9
    1.3K views 9 comments Most recent by Paul Newcome Using Smartsheet
  • Dashboard access via link not showing the user as logged in.
    In Using Smartsheet
    So, I am having an issue with my published dashboard. I have embedded a report utilizing the current user function. I have found that when my team accesses the dashboard by manually navigating to it through SmartSheet, the report works per…
    125 3
    125 views 3 comments Most recent by Genevieve P. 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…
    1126 12
    1.1K views 12 comments Most recent by Bec Nissen Using Smartsheet