Conditional Formatting

Linda McGee

Is there a way to add a conditional format to a cell that has a drop down RYG...like project health? If a task date is past due, I want the health cell to change from green to yellow automatically.  Thanks for any help!

Shaine Greenwood

Hi Linda,

You can achieve this through a nested IF formula, rather than through conditional formatting.

Here's a Smartsheet blog detailing how to create a nested IF to automate RYG balls: https://www.smartsheet.com/blog/support-tip-automate-RYG-balls

 

Linda McGee

Thank you!