I am attempting to create KPI's for a column named "Template Received" (YES/NO drop down selection) based upon a Calculated Column that either turns the YES into "1" or the NO into "0". I am having trouble because my calculated column is showing all NO's and no numbers what so ever. Please assist in showing me what it is i am doing wrong! (SharePoint 2013)

=IF([Template Received]=TRUE,"1",IF([Template Received]=FALSE,"0"))

enter image description here

1 Answer 1


Looks like you created a "Choice (menu to choose from)" field instead of "Yes/No (check box)". So you have to compare the actual value and not TRUE or FALSE.

This should work if Template Received is a Choice field with YES and NO as drop down options.

=IF([Template Received]="YES",1,0)

  • Yes... correct It was a choice menu. And thank you very much... that worked perfectly!
    – Allan
    Jan 8, 2015 at 16:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.