Discussion List

  • Creating training Calendar
    In Formulas and Functions
    Hi All, I am currently trying to create a sheet to track who our trainers are currently working with. Currently have 15 trainers, but the team will grow larger in the next few months. Each trainer can train 2 employees at a given time. Emp…
    Answered - Pending Review
    47 11
    Answered - Pending Review 47 views 11 comments Most recent by NP2_ Formulas and Functions
  • Timestamping
    In Formulas and Functions
    Hello. Is there currently anyway to do timestamping in Smartsheets?  For instance, timestamping a cell when a tick box cell is ticked? Thanks             Andrew  
    114 10
    114 views 10 comments Most recent by Andrée Starå Formulas and Functions
  • Help with Trend Data
    In Formulas and Functions
    I need some help with collecting data for trending.  Currently, I have multiple projects with all of their top line data dynamically linked to a Roll-up Sheet.  On this roll-up sheet I have data that is calculated from the project Status. …
    1400 15
    1.4K views 15 comments Most recent by Nora G Formulas and Functions
  • Automatic Predecessor Adjustment
    In Formulas and Functions
    Hey All! I have a question about how to have predecessors or just tasks in a schedule to automatically update when they are moved in the schedule. I am trying to create a production schedule for our Sheet Metal shop and it is created with…
    325 7
    325 views 7 comments Most recent by Lllllloyd Formulas and Functions
  • Best Method to Track Resource Loading by Individual & Their List of Tasks
    In Using Smartsheet
    Hello, I work in manufacturing and have used Smartsheet in the past and taken advantage of the "issues/task" list template for a specific capital project and modified to fit my needs. It worked great. I set up a very simple dashb…
    Answered - Pending Review
    30 2
    Answered - Pending Review 30 views 2 comments Most recent by MPMurphy 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…
    20 9
    Accepted Answer 20 views 9 comments Most recent by Andrée Starå Using Smartsheet
  • Formula if cell is blank then, if cell is not blank then....
    In Formulas and Functions
    Formula gods, looking for help, please. I'm trying to write a formula that says if the finish date is not blank, then the QA status is Green, if finish date is blank, then go to the days open field and if less than >= 60 and <=89 th…
    5206 12
    5.2K views 12 comments Most recent by Andrée Starå Formulas and Functions
  • % Complete based on Todays date, Start and End dates
    In Formulas and Functions
    I'm looking to return a % complete based on the start and end dates and the current date. So if a task starts on the 17/7 and ends on the 31/7, and today is the 24/7 - the % complete would be 53%. - (I want to have this as a separate colu…
    336 4
    336 views 4 comments Most recent by AlexK_Emburse Formulas and Functions
  • Excel Import
    In Using Smartsheet
    What are the prerequisites for importing an Excel spreadsheet into a new sheet.  I read number of columns, size and row constraints, which my Excel spreadsheet meets.  I am getting a warning regarding fields cannot be more than 50 characte…
    Answered - Pending Review
    399 4
    Answered - Pending Review 399 views 4 comments Most recent by Madalyn Nelson Using Smartsheet
  • Reference Codes
    In Formulas and Functions
    Hi, I am looking to have a single reference code or number that is attached to an update request that contains multiple rows. Is there a best way to do this? My first thought is to have a value added to a cell when the reference goes out…
    Answered - Pending Review
    12 2
    Answered - Pending Review 12 views 2 comments Most recent by bvannuland Formulas and Functions