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

Thomas Lince

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

Paul Newcome

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.

Purnima Gore

Hi

It would be helpful to see the sheet that you have the information in. If you post that, perhaps I can figure it out.

Thanks

Purnima

Andrée Starå

Hi @Thomas Lince

Yes, I agree with Purnima. Screenshots would be helpful.

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Paul Newcome

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.

Andrée Starå

@Paul Newcome Nice catch Mr. Hawkye! 🤣

https://media.giphy.com/media/Wo2HWPDqBbPpK/giphy.gif

Paul Newcome

@Andrée Starå HAHAHAHAHA! I just had a few others with the smart quotes right before getting to that one, so I am already "eyeing" those first today.

Thomas Lince

Wow, that's exactly what it was! It's working now. Thank you so much Paul!!!

Paul Newcome

Happy to help! 👍️