Conditional Formatting Not Working on New Sheets

Options

Hello,

Existing sheets (grids) the existing conditional formatting rules are working.

Any new sheets (grids) that I create, the conditional formatting is not working.

My rule is very basic.

Any ideas?

Thanks - Renee

Answers

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    Options

    Can you share a screenshot of your new sheet and the conditional formatting rule?

  • Renee Sprague
    Options

    Hi Mike,

    Moments after I submitted this, I got it working.

    1. I was selecting the color to change for the Task Bar rather than the paint fill. That solved issue #!.
    2. I had to re-order my tasks so that Status = Resolved trumped Priority.

    When the Priority = P1, the entire row turns red.

    When that issue Status changes to "Resolved" the entire row turns green

    Thanks



  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    Options

    Awesome. Yes, glad you figured it out. Smartsheet conditional formatting does apply formatting from top to bottom.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!