Priority Rating with Formula Logic
New to smartsheets and the Formula and I am basically trying to set up a priority rating system.
There are 4 priorities and 4 questions. If all questions are answered yes and the one checkbox is check then it gets a rating of P1 but if 2/3 questions are yes and the checkbox is checked then its p2 and so on and so on.
I am not sure if this can be done or not.
I have started by trying to get at least 1 priority to show with this logic
=IF(AND(Emergency1 = "1", Launch1 = "Yes", Escalated1 = "Yes", [CSAT 75%]1 = "Yes"), "P1")
But nothing populates the cell when the criteria is met. Any suggestions would be welcomed
Comments

Welcome to the community!
Try removing the quotes from around the 1. When referencing a checkbox, it is the numerical value that is used for true/false.
1 = true/checked
0 = false/unchecked
.
"1" or "0" will look for that exact TEXT, so unless the 1 or 0 is actually displayed in the cell, it won't register.
Help Article Resources
Categories
Check out the Formula Handbook template!