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.
Help Article Resources
Check out the Formula Handbook template!