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
This discussion was created from comments split from: Cant access sheets.
Hi, I set up an automation to copy a row from someone's intake sheet when they assigned it to my team into my intake sheet. We did this so we didn't miss any of the metadata they are capturing. Can I set up an automation that copies a column that has "DAM Link(s)" from my intake sheet back into the original intake sheet…
Hi, how can I prevent to trigger if I have a blank cell in a specific column and inform the user that the automation did not work because the cell should not be blank ? Thanks in advance Fodil
