I can't figure out what's wrong with my formula. I keep getting an "#Unparseable" Error. Help?

Can someone help me figure out why my formula keeps giving me an error? I can't for the life of me figure it out:

=IF(AND([8p LTC Peak]2 < $[8p LTC Peak]$1 + Green#, [8p LTC Peak]2 > 0), "Green", IF(AND([8p LTC Peak]2 < $[8p LTC Peak]$1 + [Blue]#, [8p LTC Peak]2 > $[8p LTC Peak]$1), "Blue”))


Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    It looks like the very last quote (after Blue) is a "smart quote". Notice how it is slanted to show that it is a close quote vs an open quote? Smartsheet formulas cannot use smart quotes. Try deleting that one and retyping it directly in Smartsheet. This should replace it with a standard quote and in turn fix the error.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!