Nested IF Statement

Good Evening,

Could someone point out the error in my syntax? I have to do quite a nestled statement as would like to use this formula to relabel existing data from an Other field to be more uniform.

=IF([Health Topics Other]@row = "Food Insecurity", "Food Insecurity", "" IF([Health Topics Other]@row = "Hand Washing", "" IF([Health Topics Other]@row = "Prostate Cancer", "Prostate Cancer","")))

Thanks for the pointers,

NCNW Inc.

Find more posts tagged with

Accepted answers

LeelaLodhi03

Just adding to my earlier note — I noticed that “Hand Washing” is currently set to return blank, so it won’t show in the formula column. If that’s intentional, please feel free to ignore 🙂

If you’d like to keep that value as well, you could update the formula to:

=IF([Health Topics Other]@row = "Food Insecurity", "Food Insecurity",
IF([Health Topics Other]@row = "Hand Washing", "Hand Washing",
IF([Health Topics Other]@row = "Prostate Cancer", "Prostate Cancer", "")))

If you found it helpful, please show some love by marking it as Insightful 💡 or Awesome ❤️, and feel free to Vote Up ⬆️.

All comments

LeelaLodhi03

Hi @NCNWIncData ,

Looks like just a small syntax issue 😊 — you’re missing commas between the IF statements, and the nesting needs to flow into the “false” part of each IF.

You can try this:
=IF([Health Topic Other]@row = "Food Insecurity", "Food Insecurity", IF([Health Topic Other]@row = "Hand Washing", "", IF([Health Topic Other]@row = "Prostate Cancer", "Prostate Cancer", "")))

Hope this helps!

LeelaLodhi03

If you’d like to keep that value as well, you could update the formula to:

NCNWIncData

Good Afternoon,

This was very helpful as my background is not in coding so explaining syntax nuance is always appreciated. 😌

Thanks,
NCNW, Inc.

LeelaLodhi03

Glad I could help

NCNWIncData

Good Afternoon,

One more question, since the IF statements have to look for the exact input, could I add a CONTAIN formula to each IF statement to pick-up those data points that aren't exact match? I tweaked one IF statement as an example, see bolded part:

=IF([Health Topics Other]@row = "Food Insecurity", "Food Insecurity", IF([Health Topics Other]@row = "Hand Washing", "Hand Washing", IF([Health Topics Other]@row = "Prostate Cancer", "Prostate Cancer", IF([Health Topics Other]@row = "Measles", "Measles", IF([Health Topics Other]@row = "Prostate Cancer", "Prostate Cancer", IF([Health Topics Other]@row = "Black men", "Black men", IF(CONTAINS("ICE", [Health Topics Other]:[Health Topics Other] = "ICE", ""))))))))

Thanks,

NCNWIncData

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.