Discussion List

  • 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  
    157 10
    157 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. …
    1610 15
    1.6K 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…
    433 7
    433 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
    98 2
    Answered - Pending Review 98 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…
    191 9
    Answered ✓ 191 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…
    6662 12
    6.7K 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…
    402 4
    402 views 4 comments Most recent by AlexK_Emburse Formulas and Functions
  • 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
    14 2
    Answered - Pending Review 14 views 2 comments Most recent by bvannuland Formulas and Functions
  • 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…
    1594 5
    1.6K views 5 comments Most recent by L_123 Formulas and Functions
  • Please add a successor column or function
    In Using Smartsheet
    A way to show successors is needed. It's important for critical path scheduling that every task has a predecessor and a successor. After a couple hundred lines it becomes nearly impossible to eyeball everything to make sure that's true. A …
    690 4
    690 views 4 comments Most recent by AW10101 Using Smartsheet