StaceySexton

3 years agoQrew Member

# Multi-Select Formula Field help

I have a Multi-Select field [Badge:Patient Type] that is calculated through a relationship in a separate table. The resulting field could contain one or more of 30 different bubbles (terms).

I need a formula that could look at that field and translate each term to a point value or number and add those numbers up. Example:

[Badge:Patient Type] field contains the value ED; Clinic; OP

[Specialty Points] field would contain a formula that said IF [Badge:Patient Type] contains "ED" then 3 PLUS if if contains Clinic, then 3 points, PLUS if it contains OP 1 point, etc.

RESULT would equal 7

Is this possible or am I thinking of this all wrong.

This is the formula I have so far:

Sum(If( Contains( [Badge: Patient Type], "Inpatient"), 5)+

If( Contains( [Badge: Patient Type], "PF-Hospitalist"), 2)+

If( Contains( [Badge: Patient Type], "PF-Surgery"), 2)+

If( Contains( [Badge: Patient Type], "PF-Anesthesia"), 2)+

If( Contains( [Badge: Patient Type], "OPS"), 3)+

If( Contains( [Badge: Patient Type], "GI"), 1)+

If( Contains( [Badge: Patient Type], "Cath"), 1)+

If( Contains( [Badge: Patient Type], "Pain"), 1)

If the underlined Patient types were found in the multi select field, then the answer would be 9

I need a formula that could look at that field and translate each term to a point value or number and add those numbers up. Example:

[Badge:Patient Type] field contains the value ED; Clinic; OP

[Specialty Points] field would contain a formula that said IF [Badge:Patient Type] contains "ED" then 3 PLUS if if contains Clinic, then 3 points, PLUS if it contains OP 1 point, etc.

RESULT would equal 7

Is this possible or am I thinking of this all wrong.

This is the formula I have so far:

Sum(If( Contains( [Badge: Patient Type], "Inpatient"), 5)+

If( Contains( [Badge: Patient Type], "PF-Hospitalist"), 2)+

If( Contains( [Badge: Patient Type], "PF-Surgery"), 2)+

If( Contains( [Badge: Patient Type], "PF-Anesthesia"), 2)+

If( Contains( [Badge: Patient Type], "OPS"), 3)+

If( Contains( [Badge: Patient Type], "GI"), 1)+

If( Contains( [Badge: Patient Type], "Cath"), 1)+

If( Contains( [Badge: Patient Type], "Pain"), 1)

If the underlined Patient types were found in the multi select field, then the answer would be 9

------------------------------

Stacey Sexton

------------------------------