need cleanup of logical formula

jrehm35926

Could someone help clean up the following formula:

 

=IF(AND(TODAY() >= Finish2, [% Complete]2 < 100), "Red", IF(AND(TODAY() < Finish2, [% Complete]2 < 100), "Yellow", "Green"))

Shaine Greenwood

Hello,

I'm not sure what you mean by clean up, exactly, but one thing I noticed is that you're using a % complete column and comparing it to 100. Smartsheet treats percentages as decimals, so 1 is 100% and 100 is 10,000% percent. 

If your formulas is doing what you expect it to, then change it to something like this:

=IF(AND(TODAY() >= Finish2, [% Complete]2 < 1), "Red", IF(AND(TODAY() < Finish2, [% Complete]2 < 1), "Yellow", "Green"))

Otherwise, let me know what you specifically need to do with your formula and I can assist further.