Nested IF formulas

Hello, I'm new round here. Please excuse the entry level ask.

I have an array of 3x3 cells. In each row only 1 of the 3 cells will be completed and I want to return a value from another cell depending on which of 2 the 3 cells are blanks.

I have these 3 formulas working as expected in isolation, but I am struggling to nest them into one formula that I can convert to a column formula.

=IF(AND(ISBLANK([Planning Phase]@row), ISBLANK([Event Type]@row)), [Task Strap]@row)

=IF(AND(ISBLANK([Task Name]@row), ISBLANK([Event Type]@row)), [Planning Strap]@row)

=IF(AND(ISBLANK([Task Name]@row), ISBLANK([Planning Phase]@row)), [Event Strap]@row)

Can anyone help with the syntax or propose a more elegant solution?

In case some background is useful. I want to apply a different strap label items in my Gantt chart depending on whether the items are Project level plans, Project Milestones or Tasks within a Sprint.

Many thanks,

Jim

Find more posts tagged with

Formulas

Accepted answers

Sameer Karkhanis

Try this,

=IF(AND(ISBLANK([Planning Phase]@row), ISBLANK([Event Type]@row)), [Task Strap]@row,

IF(AND(ISBLANK([Task Name]@row), ISBLANK([Event Type]@row)), [Planning Strap]@row,

IF(AND(ISBLANK([Task Name]@row), ISBLANK([Planning Phase]@row)), [Event Strap]@row)))

All comments

Sameer Karkhanis

Try this,

=IF(AND(ISBLANK([Planning Phase]@row), ISBLANK([Event Type]@row)), [Task Strap]@row,

IF(AND(ISBLANK([Task Name]@row), ISBLANK([Event Type]@row)), [Planning Strap]@row,

IF(AND(ISBLANK([Task Name]@row), ISBLANK([Planning Phase]@row)), [Event Strap]@row)))

Jim B

Yep. That's it. Pesky brackets!!

Thanks so much for your help you have saved me many hours of unscrambling.

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.