IF And

bday2329 ✭✭✭✭
edited 12/09/19 in Formulas and Functions

Good Day,

I need so assistance, I am trying to do the following

I want to change my Project stoplight Status Column (RYGB ball) to yellow if the following condition is met

if my "# of Days" column is > 138 and my "% Complete" column is < 50%

Here is my If condition - =IF(AND(([# of Days]2 > 138, ([% Complete]2 < 50)), "Yellow", "Green")))

Where am I going wrong I get #unparseable error


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!