Conditional Formatting

Discussion List

  • Completed Tasks removed from calendar
    In Using Smartsheet
    Is there a way to remove completed tasks from the calendar without removing them from the sheet? I have a done column that checks off and greys out the row but the information still shows up on the calendar is there a way for it not to sho…
    Answered - Pending Review
    42 2
    Answered - Pending Review 42 views 2 comments Most recent by Sara Moore Using Smartsheet
  • How to calculate elapsed time between status changes ?
    In Formulas and Functions
    Hello, Is there a way to calculate the elapsed time between two status changes ? I would need to know how much time it took for the status to change from yellow or red to green. Ideally, I would like to be able to calculate a mean per terr…
    Answered - Pending Review
    74 2
    Answered - Pending Review 74 views 2 comments Most recent by Nicolas Houle Formulas and Functions
  • Flag or Conditional Formatting?
    In Formulas and Functions
    I want a way to 'flag' a cell if it is out of range of two other cell dates. I haven't been able how to do that with conditional formatting because I can't set a condition to say if "this column" is NOT between "this column&…
    Accepted
    22 2
    Accepted Answer 22 views 2 comments Most recent by Morgan E Kelly Formulas and Functions
  • Creating a Formula for Dates and Traffic Lights
    In Formulas and Functions
    Hi, all! Our office is new to the SmartSheet community.  I am having some trouble creating a formula for a sheet.  I have the following columns: * "Initial Contact" - formatted as a date * "30 Days Since Contact" - fo…
    809 11
    809 views 11 comments Most recent by Ess Formulas and Functions
  • Averaging RGB balls
    In Formulas and Functions
    I'm hoping this is quite simple, but my simple mind is struggling to piece it together. I have a Parent Row with multiple Children but only one hierarchy below it and i want the parent row to average the status of the Red, Green and Blue …
    Accepted
    74 7
    Accepted Answer 74 views 7 comments Most recent by Gunn_Jack Formulas and Functions
  • Unable to Edit 1 Column on a Spreadsheet
    In Using Smartsheet
    Hello all, I am working on a collaborative spreadsheet on which I am an administrator. All I am trying to do update a vlookup function for one column, which references a different spreadsheet, on which I am also an administrator. The spre…
    Accepted
    35 1
    Accepted Answer 35 views 1 comment Most recent by Kelly Moore Using Smartsheet
  • if formula help
    In Formulas and Functions
    I am trying to do a formula that states: if there is text in the column2 then place a "1" in the primary column. @Paul Newcome
    Answered - Pending Review
    22 4
    Answered - Pending Review 22 views 4 comments Most recent by Mike Wilday Formulas and Functions
  • Copy , move or share selected cells / information with others
    In Using Smartsheet
    Hi All How to copy/move or to share rows to another sheet with column of my choice . or to share some cells / columns of my choices with others but not all row information The reason is i donot want to share some information with others…
    Answered - Pending Review
    31 4
    Answered - Pending Review 31 views 4 comments Most recent by Leibel Shuchat Using Smartsheet
  • Create Summary Sheet
    In Using Smartsheet
    Hi, I have been unable to create a summary sheet which I think will work better with charts on the dashboard. I created this report but want to do the same thing in a metric sheet. I am lost as to how to accomplish this. Any advice?
    Answered - Pending Review
    32 5
    Answered - Pending Review 32 views 5 comments Most recent by Andrée Starå Using Smartsheet
  • Add date to formula
    In Formulas and Functions
    Hi I am currently using this formula =SUMIFS([Number of Slides]:[Number of Slides], Done:Done, 0, Status:Status, "Handed to Pathologist") I want to look at the date for the next 30 days. I have a column titled "Due Date&quo…
    Accepted
    21 2
    Accepted Answer 21 views 2 comments Most recent by Sara Moore Formulas and Functions