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

Find more posts tagged with

Formulas

Accepted answers

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.

All comments

Purnima Gore

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

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! 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.