Green, Yellow, Red Blue Formatting


Newbie here. Trying to set some formatting for some specific RYGB and I can only get it to work for Yellow. Any thoughts? I receive the #INCORRECT ARGUMENT error. Thanks in advance!

=IF([Completed%]2 = 1, "Green", IF(AND(Today1 > Start2, Today1 < Finish2, [Completed%]2 = 0), "Yellow", IF(Start2 > $Today$1, [Completed%]2 = 0, "Blue", IF($Today$1 > Finish2, "Red"))))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!