Formula Assistance

Hello,

I have a formula that works but need to add more variables to it. So when certain criteria are met then it produces a certain response. However, for the heart failure, I need to also include regular or bariatric scale, so I think i need to add and AND to the formula but cant figure it out.

=IF([CareKit Type Requested]@row = "Hypertension", "Blood Pressure Kit", IF([CareKit Type Requested]@row = "Heart Failure", "Heart Failure Kit w/Bariatric Scale", IF([CareKit Type Requested]@row = "Diabetes", "Blood Sugar Control Care Kit", IF([CareKit Type Requested]@row = "COPD", "COPD Kit"))))

Find more posts tagged with

Accepted answers

All comments

=Chris Palmer

Hello @CaraBart28

You can give this a shot for the AND:

=IF([CareKit Type Requested]@row = "Hypertension", "Blood Pressure Kit",
IF(AND([CareKit Type Requested]@row = "Heart Failure",
[Kit Type Requested]@row = "Heart Failure Kit w/Bariatric Scale"),"Heart Failure Kit w/Bariatric Scale",
IF([CareKit Type Requested]@row = "Diabetes", "Blood Sugar Control Care Kit",
IF([CareKit Type Requested]@row = "COPD", "COPD Kit"))))

Alternatively, if it's suitable for your requirements, you can use:
IF(CONTAINS this will simply capture any mention of "Heart Failure" in [CareKit Type Requested]@row
to say "Heart Failure"

=IF(CONTAINS("Heart Failure", [CareKit Type Requested]@row), "Heart Failure",
IF([CareKit Type Requested]@row = "Hypertension", "Blood Pressure Kit",
IF([CareKit Type Requested]@row = "Diabetes", "Blood Sugar Control Care Kit",
IF([CareKit Type Requested]@row = "COPD", "COPD Kit", ""))))

Let me know if any of these options work for you : -)

CaraBart28

The first one is not working. I am getting the same syntax error. So I need for it to either return Heart Failure Kit with Bariatric Scale if they choose heart failure and the helper column returns bariatric scale, or I need it to return heart failure kit with regular scale if the type is heart failure and the helper column is regular scale.

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.