Conditional Formatting

Discussion List

  • CheckBox Formula
    In Formulas and Functions
    Greetings! So, I have a "Done" column and a "Status" column. Status column values = Not Started , In Progress, Complete Done value = Checkbox The Goal: When I check the "Done", I would like to have the Stat…
    Answered - Pending Review
    68 2
    Answered - Pending Review 68 views 2 comments Most recent by Melita Clark Formulas and Functions
  • Is it possible to send specific columns of two spreadsheets to a third one?
    In Using Smartsheet
    Hi everyone I have two spreadsheets and I want to take some columns of sheet 1 and others from sheet 2 and put them in a third one and that every time an update is made in sheet 1 or 2, it also apply on the third one. Including new rows, d…
    Answered - Pending Review
    12 1
    Answered - Pending Review 12 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • SUM cells with formulas not working
    In Formulas and Functions
    Hello, I have a sheet with a column of cells with formulas in them. These formulas produce numbers. Then I have a second sheet, where I have a formula in a cell that references the first sheet's column with numbers. This formula in the sec…
    736 12
    736 views 12 comments Most recent by Sunil Kadikar Formulas and Functions
  • Formula Quesiton
    In Using Smartsheet
    I have 2 columns - one Engagement and one Desired Engagement - If the two columns are not equal, I want the cell color to be yellow as an indicator. If the two columns are equal then, do nothing. How can write that formula in smartsheets (…
    Accepted
    22 3
    Accepted Answer 22 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • 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
    50 2
    Answered - Pending Review 50 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
    89 2
    Answered - Pending Review 89 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
    26 2
    Accepted Answer 26 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…
    876 11
    876 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
    103 7
    Accepted Answer 103 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
    47 1
    Accepted Answer 47 views 1 comment Most recent by Kelly Moore Using Smartsheet