Most RecentMost ViewedMost LikesFormula help needed Hi all. I need help with a simple formula, I've been trying for days, but I'm unable to find a solution... In a list, I have: A column called [Power] with choices from 1 to 4. A column called [Impact] with choices from 1 to 4. A column called [Total_Score] with formula= [Power]*[Impact]. My quest: A column called [Management_Style], a calculated column, where I would like to make a matrix (powerXImpact) Matrix: If power =3 or 4, and impact = 3 or 4; then "Manage Closely" If power= 3 or 4, and impact =1 or 2; then "Keep Satisfied" if power = 1 or 2, and Impact = 3 or 4; then "Keep Informed" If power= 1 or 2, and impact= 1 or 2; then "Monitor (Minimum Effort)" I tried many types if multiple IFs, ANDs, ORs, but I could not find the right formula. Any help is really appreciated. Thank you all! SolvedNo validation for multi choice column Hello, I have a multichoice column in which I need to specify a formula for validation, but I can't.. Any ideas if that is possible in sharepoint list plz ?? Thanks in advance !
