Hi,
I'm trying to write a formula that will display "Highly Critical", "Fairly Critical" or "Non-Critical" in a text field depending on whether certain responses are selected in the form. If "Highly Critical" is true I want the formula to exit before the assessment for "Fairly Critical starts and if "Fairly Critical" I want the formula to exit before the "Non Critical" assessment starts. So functionality similar to a Switch statement in Java.
My formula is below. Currently, the assessments for fairly critical / non critical are overriding previous calculations. Is there a way to fix this please?
If (DataCardValue51_1.Selected.Value="Statement 1" || DataCardValue50_1.Selected.Value="Statement 2"|| DataCardValue62_1.Selected.Value="S3" || DataCardValue46_1.Selected.Value="S4" || DataCardValue45_1.Selected.Value="S5" || DataCardValue12_1.Selected.Value="s6"||DataCardValue33_1.Selected.Value="S7", "Highly Critical",
DataCardValue51_1.Selected.Value="A" ||DataCardValue48_1.Selected.Value="B" || DataCardValue62_1.Selected.Value="C"||DataCardValue47_1.Selected.Value="C"||DataCardValue45_1.Selected.Value="D"||DataCardValue12_1.Selected.Value="E"|| DataCardValue33_1.Selected.Value="F", "Fairly Critical",
"Non Critical")