Forum Discussion
YDRDK
Jun 03, 2022Copper Contributor
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...
RobElliott
Jun 03, 2022Silver Contributor
YDRDK your brackets/parentheses are in the wrong place. It should be:
=IF([Pre Likelihood]="Unlikely",1,(IF([Pre Likelihood]="Possible",2,(IF([Pre Likelihood]="Likely",3,4)))))
Pre Likelihood is the Choice Column, LikelihoodScore is the calculated column:
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)