I would like a value to be displayed as text in Formula column

Hello dear Community,
Im new to monday and our nonprofit is trying to create a CSP PHQ2 PHQ9 C-SSRS Screens. I was able to create formulas to calculate results but Im having hard time to create a formula to display results based on calculations. Hope someone can help!
IF({PHQ9} ≤ 4, SWITCH({Scores ≤4 suggest minimal depression which may not require treatment. Functionally, the patient does not report limitations due to their symptoms.}, 0) + IF({PHQ9 } = 5-9, SWITCH({Scores 5-9 suggest mild depression which may require only watchful waiting and repeated PHQ-9 at followup. Functionally, the patient does not report limitations due to their symptoms.}, 0) + IF({PHQ9} = 10-14, SWITCH({Scores 10-14 suggest moderate depression severity; patients should have a treatment plan ranging form counseling, followup, and/or pharmacotherapy. Functionally, the patient does not report limitations due to their symptoms.}, 0) + IF({PHQ9} = 15-19, SWITCH({Scores 15-19 suggest moderately severe depression; patients typically should have immediate initiation of pharmacotherapy and/or psychotherapy. Functionally, the patient does not report limitations due to their symptoms.}, 0)

@costavia

Try this:

IF({PHQ9} <= 4, 
"Scores ≤4 suggest minimal depression which may not require treatment. Functionally, the patient does not report limitations due to their symptoms.", 

IF({PHQ9} <= 9, 
"Scores 5-9 suggest mild depression which may require only watchful waiting and repeated PHQ-9 at followup. Functionally, the patient does not report limitations due to their symptoms.", 

IF({PHQ9} <= 14, 
"Scores 10-14 suggest moderate depression severity; patients should have a treatment plan ranging form counseling, followup, and/or pharmacotherapy. Functionally, the patient does not report limitations due to their symptoms.", 

IF({PHQ9} <= 19, 
"Scores 15-19 suggest moderately severe depression; patients typically should have immediate initiation of pharmacotherapy and/or psychotherapy. Functionally, the patient does not report limitations due to their symptoms.", "???"))))

Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: A Status Column Tip - When is “Done” really DONE?
Contact me directly here: Contact – The Monday Man

Thank you very much for fast reply.

1
I forgot to add the last one:
IF({PHQ9} => 20,
"Scores 20 and greater suggest severe depression; patients typically should have immediate initiation of pharmacotherapy and expedited referral to mental health specialist. Functionally, the patient does not report limitations due to their symptoms. WARNING: This patient is having thoughts concerning for suicidal ideation or self-harm, and should be probed further, referred, or transferred for emergency psychiatric evaluation as clinically appropriate and depending on clinician overall risk assessment.

2
Looks like formula doesn’t pick up a number in a range (ex: IF({PHQ9} <= 15-19; for number 17 it displays ???)

@costavia

I fixed the error in the first post. 17 will now work.

Here is the formula with the addition of > 19:

IF({PHQ9} <= 4, 
"Scores ≤4 suggest minimal depression which may not require treatment. Functionally, the patient does not report limitations due to their symptoms.", 

IF({PHQ9} <= 9, 
"Scores 5-9 suggest mild depression which may require only watchful waiting and repeated PHQ-9 at followup. Functionally, the patient does not report limitations due to their symptoms.", 

IF({PHQ9} <= 14, 
"Scores 10-14 suggest moderate depression severity; patients should have a treatment plan ranging form counseling, followup, and/or pharmacotherapy. Functionally, the patient does not report limitations due to their symptoms.", 

IF({PHQ9} <= 19, 
"Scores 15-19 suggest moderately severe depression; patients typically should have immediate initiation of pharmacotherapy and/or psychotherapy. Functionally, the patient does not report limitations due to their symptoms.", 

"Scores 20 and greater suggest severe depression; patients typically should have immediate initiation of pharmacotherapy and expedited referral to mental health specialist. Functionally, the patient does not report limitations due to their symptoms. WARNING: This patient is having thoughts concerning for suicidal ideation or self-harm, and should be probed further, referred, or transferred for emergency psychiatric evaluation as clinically appropriate and depending on clinician overall risk assessment."))))

Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: A Status Column Tip - When is “Done” really DONE?
Contact me directly here: Contact – The Monday Man

Absolutely amazing,
You are THE MAN, Jim!

1 Like