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
------------------------------