Formula Help

CaraBart28

Hello,

I am trying to get the formula to produce an outcome that will display the type of kit being ordered from various data points. So I need to to display for instance "Heart Failure Kit Non-Bariatric Scale" or "Heart Failure Kit Bariatric Scale" however I keep receiving the unpears error. So it will need to produce the output from combining the data from the CK Type Helper, CareKit Educational Language and Weight/Scale Helper Columns.

Paul Newcome

Try this:

=[CK Type Helper]@row + " " + IF(CONTAINS("Regular Scale", [Weight/Scale Helper Column]@row), "Regular Scale", IF(CONTAINS("Bariatric Scale", [Weight/Scale Helper Column]@row), "Bariatric Scale", [Educational Language Helper]@row))

CaraBart28

HI Paul,

That returned a response, however it returned a blood pressure kit response. So if it is anything other than Heart Failure I need to to return a blank response.

Thanks!

Paul Newcome

My apologies. I didn't notice that requirement initially. Give this one a try:

=IF([CK Type Helper]@row = "whatever would indicate a heart failure kit", [CK Type Helper]@row + " " + IF(CONTAINS("Regular Scale", [Weight/Scale Helper Column]@row), "Regular Scale", IF(CONTAINS("Bariatric Scale", [Weight/Scale Helper Column]@row), "Bariatric Scale", [Educational Language Helper]@row)))

CaraBart28

Almost there, it is pulling the data minus the language at the end

Paul Newcome

It looked like your other formula was only pulling language if the helper was blank. If you want it added in regardless of helper column, it would look more like this:

=IF([CK Type Helper]@row = "whatever would indicate a heart failure kit", [CK Type Helper]@row + " " + IF(CONTAINS("Regular Scale", [Weight/Scale Helper Column]@row), "Regular Scale", IF(CONTAINS("Bariatric Scale", [Weight/Scale Helper Column]@row), "Bariatric Scale", "")) + " " + [Educational Language Helper]@row)

CaraBart28

Perfect!!! Thank you so much!

Paul Newcome

Happy to help. 👍️