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"))