Forum Discussion

YDRDK's avatar
YDRDK
Copper Contributor
Jun 03, 2022

Calculated colulm

Hi,   I am trying to create a calculated column in my SharePoint list, which is based on a choice column. I would like to set it up as follows:  If my calculated column (Pre Likelihood) is unlike...
admin
developer
SharePoint Online
Sites
ganeshsanap's avatar
ganeshsanap
MVP
Jun 04, 2022

YDRDK You are very close with your 1st formula. You just need to provide default/false value for your last IF statement like:

 

=IF([Pre Likelihood] = "Unlikely", "1", IF([Pre Likelihood] = "Possible", "2", IF([Pre Likelihood] = "Likely", "3", IF([Pre Likelihood] = "Very likely", "4", "0"))))

 

Here I have added "0" as a default value in last statement.

Note:

  1. Sometimes comma(,) does not work in formula (I am not sure but it is based on something language or regional settings on your site). So in that case use semicolon(;) instead of comma(,).

Official Documentations:

  1. Calculated Field Formulas.
  2. IF function.

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Resources