nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Alerts

Robert Hall

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

Find more posts tagged with

Conditional Formatting

Project Management

Comments

Alison

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,

Alison

Smartsheet Support

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

Sign in to join the conversation!

Quick Links

Trending discussions

Run Generate Document Workflow On Multiple Rows
Hello everyone, I have several rows (different entries) that I would like to enter on a custom form using the "Generate Document" workflow. I did a test run and it just generated "individual" PDF form per row - and not multiple rows merged into one form as I was expected. Is there another way or methodology around this or…
Sharing a Single Smartsheet with External Partners (No SSO Access)
Hi Smartsheet Community, I’m hoping you can help clarify a Smartsheet sharing question. I’m trying to share one specific sheet from my Smartsheet plan with two external colleagues from our partner organization. Several colleagues have mentioned they’ve successfully shared sheets with external partners before, so I’m hoping…
Form Creation
Is it possible to create a form on sheet 1 with information from sheet 2? On Sheet 1, I'm tracking what we ship and receive. On Sheet 2, I'm tracking the shipping requirements. I want to pull data from this sheet for a shipping request form on sheet 1.