Nested Ifs not working

Hey,

I'm trying to create some nested ifs for grid logic.

This works perfectly for one if statement

=IF(LOE@row = "Large", "12", “Empty”)

But once I start to nest, it does not, and I've tried multiple combinations of parens and read the articles, etc, but it keeps saying #UNPARESEABLE"

=IF(LOE@row = "Large", "12", IF(LOE@row = “Small”, "4”, "Empty”))

Where I am trying to go is something like this, but I need above to work first!

=IF(LOE@row = "Extra Large", "20", IF(LOE@row = “Large”, "12", IF(LOE@row = “Medium”, "8", IF(LOE@row = “Small”, "4", IF(LOE@row = “Extra Small”, "1”, "Empty”)))))

(I also tried IF([LOE]@row based on other articles, but Smartsheet just deletes the [] brackets)

What am I doing wrong?

Find more posts tagged with

Formulas

Accepted answers

AravindGP

Hi Rebecca,

When you're entering numeric values as results in formulas, you don't need to add it in quotes. It is only needed for strings. Here's the formula you can use.

=IF(LOE@row = "Extra Large", 20, IF(LOE@row = "Large", 12, IF(LOE@row = "Medium", 8, IF(LOE@row = "Small", 4, IF(LOE@row = "Extra Small", 1, "Empty")))))

All comments

AravindGP

Hi Rebecca,

When you're entering numeric values as results in formulas, you don't need to add it in quotes. It is only needed for strings. Here's the formula you can use.

=IF(LOE@row = "Extra Large", 20, IF(LOE@row = "Large", 12, IF(LOE@row = "Medium", 8, IF(LOE@row = "Small", 4, IF(LOE@row = "Extra Small", 1, "Empty")))))

rebeccakbaker

Thank you so much!

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.