Nested if helper column to set project size

Hi all,

I am trying to create a nested if statement to set the project size to Small, Medium, or Large based on the estimated number of hours that project will take. This is what I have:

=IF([Est Effort (Total Hrs)]@row = "30-120 (2-3 weeks)", "Small", IF([Est Effort (Total Hrs)@row = "120-320 (1-3 months)", "Medium", IF([Est Effort (Total Hrs)@row = ">320 (>3months)", "Large", 0)))

Not sure if I am missing something here, appreciate any help.

Find more posts tagged with

Sheets

Formulas

Automations

Accepted answers

Dale Murphy

@Henry L. You are missing at least two closing brackets on column names:

When you build a formula, if all the column names don't light up you have a syntax issue. You probably want to avoid column names with round brackets.

Your logic seems sound, fixing the syntax will help.

Cheers,

All comments

Henry L.

To add to this post: I am trying to use terms from a dropdown column. Does this work or would I have to use Text/Number?

Dale Murphy

@Henry L. You are missing at least two closing brackets on column names:

When you build a formula, if all the column names don't light up you have a syntax issue. You probably want to avoid column names with round brackets.

Your logic seems sound, fixing the syntax will help.

Cheers,

Henry L.

https://community.smartsheet.com/discussion/comment/345755#Comment_345755

Thanks, that was it. You're right, all these brackets and parenthesis get confusing.

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.