Sign in to join the conversation:
How do I change a row color if project is past due
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,
AlisonSmartsheet Support
I have tried to set them as Edit - can share, Edit - cannot share, and commenter and nothing works, they cannot add data to the sheet. Does anyone have a solution?
The Issue My project-specific metadata sheets use INDEX/MATCH formulas that reference the Intake sheet using a Project ID. When the automation archives rows from the Intake sheet, these formulas break because they can no longer locate the source data. Example formula: =INDEX({Project Intake Name}, MATCH([Project ID 1]@row,…
Two of my five automation workflows appear to have just randomly stopped performing on April 9, 2026. All others, which would/are performing as normal and would be functioning alongside the other workflows, are functional and appear to be untouched by this 'bug'. Help I've tried all that I can think of.
