Unparseable "IF" Formula

Can someone help me understand what is 'unparseable" about this formula? =IF(AND(Finish21<=TODAY(), STATUS21=2)), "RED", "GREEN"  Whereas I have a finish date in column "Finish" and a checkbox complete in column "status" and I want to create a red color dot if the date is past and the status is unchecked, otherwise a green dot in this helper column.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!