Robert Hall
edited 12/09/19 in Smartsheet Basics

How do I change a row color if project is past due


  • Alison
    Alison Employee

    Hello Robert,

    Thanks so much for this question.  The best way to do this would be to set up a Conditional Formatting rule based on the Due Date column you have.  If your Due Date column is a date-type column, you'll be able to set up the rule to change the color of the cell or the row if the date is in the past.  I've attached a screenshot of this.

    A tip that I have is to make sure that you're selecting the paint bucket icon since you're looking to have the background color changed; the Task Bar option will only change the color of a Gantt taskbar, so you won't see any changes on your regular grid view.

    Kind regards,


    Smartsheet Support


    Screen Shot 2018-01-28 at 9.09.48 PM.png