Unparseable error with "IF"

Good day everyone,

I'm having issues with the IF formula on Smartsheet. I tried to do it as I typically do it on excel but I think I'm missing something in here.

Here's the formula that I'm using:

The thing what I want to do is if the Growth is over 100%, I want the result ">100%" in the cell. If not, I want the result of the operation on it.

Just like here:

But I get the Unparseable error over and over again.

Any help will be greatly appreciated.

Find more posts tagged with

Formulas

Accepted answers

Devin Lee

Hey @Yahaira Paredes

Smartsheet doesn't operate with % symbols in formulas. Percent is only a format for the time being. The formula below should work for you.

=IF([2021]@row / [2020]@row - 1 > 1, ">100%", [2021]@row / [2020]@row - 1)

All comments

Devin Lee

Hey @Yahaira Paredes

Smartsheet doesn't operate with % symbols in formulas. Percent is only a format for the time being. The formula below should work for you.

=IF([2021]@row / [2020]@row - 1 > 1, ">100%", [2021]@row / [2020]@row - 1)

Yahaira Paredes

Thank you very much! It worked.

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.