To set RYG using a formula that considers Todays date and Completion %

MWatson

I would like to set the risk RYG status column colour based on set conditions.

 

IF % complete = 0 And 'start' is todays date to show Risk 

 

IF % complete = between 90 & 100 to show Green 

 

somethign like this but it doesn't work 

 

=IF(AND([%  Complete]row# = "0", [Start]165="TODAY", "Red"))

 

Any ideas?

Matt Hines

I think there are a few things.

 

Instead of this:

=IF(AND([%  Complete]row# = "0", [Start]165="TODAY", "Red"))

 

Try this:

=IF(AND([%  Complete]165 = 0, [Start]165=TODAY()), "Red", "Yellow")

 

I think that should work.