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

Thomas Lince
Thomas Lince ✭✭
edited 07/09/20 in Formulas and Functions

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”))

Tags:

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.

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!