Conditional Formatting

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  
    155 10
    155 views 10 comments Most recent by Andrée Starå Formulas and Functions
  • Indenting on smartsheet causing calculation error- help?
    In Formulas and Functions
    Hello, My organization uses smartsheet as a scheduling tool. We have a column that calculates what resource hours we have remaining for available scheduling (formula =((# of crew members * work days * work hours) - SUM(CHILDREN())) in my …
    Accepted
    24 3
    Answered ✓ 24 views 3 comments Most recent by Heather Duff Formulas and Functions
  • IF AND Statement for Color Statuses
    In Formulas and Functions
    I am trying to do something that I thought was fairly simple, but I keep running into an issue and receive an "#Unparceable" with my current formula. I am trying to build a Task Status based on Red, Yellow, Blue, and Green Cir…
    4520 19
    4.5K views 19 comments Most recent by Kelly Moore Formulas and Functions
  • Getting top-level heading's rank
    In Formulas and Functions
    I'm trying to write a formula that extracts the position of the current hierarchy's top-level heading within the set of all top-level headings. The purpose is to drive some conditional formatting. i.e. If the current row is under the first…
    Answered - Pending Review
    101 1
    Answered - Pending Review 101 views 1 comment Most recent by Genevieve P. Formulas and Functions
  • How do I get conditional formatting rules to update based on "today" as the date.
    In Formulas and Functions
    Hi All! I have conditional formatting set up that is looking for tasks that are due to start today (see first picture below). I chose the "Today" button when I set these up, but they populated today's date and they don't automat…
    Accepted
    17 2
    Answered ✓ 17 views 2 comments Most recent by PattiL Formulas and Functions
  • Calculation within IF statement
    In Formulas and Functions
    Hello, I have a column formula that calculates the number of days between a ticket request and the completion date. I want the rows that do not yet have a completion date to be blank instead of "#INVALID DATA TYPE" and I tried to…
    Accepted
    43 2
    Answered ✓ 43 views 2 comments Most recent by GTigs Formulas and Functions
  • Have cells inherit background color
    In Using Smartsheet
    So, I have a helper sheet that tracks Budgeted, Committed and Actual spend for an individual project based on the end date from a project sheet. The sheet is laid out where a total of 24 months have their own columns in chronological order…
    Answered - Pending Review
    58 8
    Answered - Pending Review 58 views 8 comments Most recent by Paul Newcome Using Smartsheet
  • Nested IF statements counting Children color status
    In Formulas and Functions
    Hey community, I've found simpler versions of this in the messages, but can't get this one correct. The logic I'd like to express is: If any children under Flag show a Red, then the parent cell (Flag1) is Red If children Yellows are >=…
    Accepted
    33 2
    Answered ✓ 33 views 2 comments Most recent by Paul Watts Formulas and Functions
  • Global Update for Conditional Formating?
    In Using Smartsheet
    We work with the control center, and we have 50 plus sheets of a template sheet. (we have approx 10 templates in the template) We need to change the conditional formatting due to a change in our drop-down lists. As of right now, we wil…
    Answered - Pending Review
    39 1
    Answered - Pending Review 39 views 1 comment Most recent by Genevieve P. Using Smartsheet
  • Frozen/Unresponsive Sheets
    In Using Smartsheet
    We're experiencing freezing/unresponsive sheets after a few moments of being open. This has been going on for a few days.  Anyone else experiencing this? Thanks
    164 7
    164 views 7 comments Most recent by Carissa Coats Using Smartsheet