Conditional Formatting Not Working on New Sheets



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


  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

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

  • Renee Sprague

    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


  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    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!