need cleanup of logical formula

edited 12/09/19 in Smartsheet Basics

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"))


  • 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.