If Statement with Multiple Factors

Hello,

Sorry for needing additional formula help. For the HTN Kit Helper, I need to it either display Blood Pressure Kit with the Educational Language Helper, except if BP cuff helper is Extra Large Cuff I need it to only display "Extra Large Cuff" in the HTN Kit Helper column

=IF([CK Type Helper]@row = "Blood Pressure Kit", [CK Type Helper]@row + " " + IF(CONTAINS("Extra Large Cuff", [BP Cuff Size Helper]@row), "Extra Large Cuff", IF(ISBLANK([BP Cuff Size Helper]@row), "", [Educational Language Helper]@row)))

Find more posts tagged with

Accepted answers

Nick Korna

Hi @CaraBart28,

A nested IF should do this for you:

=IF([BP Cuff Size Helper]@row = "Extra Large Cuff", "Extra Large Cuff", IF([CK Type Helper]@row = "Blood Pressure Kit", [CK Type Helper]@row + " " + [Educational Language Helper]@row, ""))

Sample output (showing only relevant columns):

Hope this helps, but if I've misunderstood anything or you've any problems/questions then just let us know!

All comments

Nick Korna

Hi @CaraBart28,

A nested IF should do this for you:

=IF([BP Cuff Size Helper]@row = "Extra Large Cuff", "Extra Large Cuff", IF([CK Type Helper]@row = "Blood Pressure Kit", [CK Type Helper]@row + " " + [Educational Language Helper]@row, ""))

Sample output (showing only relevant columns):

Hope this helps, but if I've misunderstood anything or you've any problems/questions then just let us know!

CaraBart28

That worked great Nick, one more question, how would I get the CareKit Name column to display what is in the HTN Kit Helper if not blank, then Heart Failure Kit Helper if not blank, then Diabetes Kit Helper if not blank, then lastly COPD Kit Helper if not blank?

Nick Korna

It'd be along the lines of:

=IF([HTN Kit Helper]@row <> "", [HTN Kit Helper]@row, IF([Heart Failure Kit Helper]@row <> "", [Heart Failure Kit Helper]@row, IF([Diabetes Kit Helper]@row <> "", [Diabetes Kit Helper]@row, IF([COPD Kit Helper]@row <> "", [COPD Kit Helper]@row))))

Sample:

If multiple columns are filled for whatever reason, it will take whichever is first in the priority (leftmost in the above).

Hope this helps!

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.