Found this one that seems to be the solution needed but i cant get it to work:

Column1 has the value of BD122

Formula: =EXACT([Column1], "BD122")

Expected result: Compares contents of Column1 and the string "BD122" Should Return value (Yes) in my calculated Column2

Running On-Premise Sharepoint 2013 Enterprise ref: http://msdn.microsoft.com/en-us/library/bb862071.aspx

  • It works. What is the error message?
    – Jinxed
    Oct 16, 2013 at 12:15
  • I'm also getting it to work. Maybe this is a missing parenthesis, comma, or quote? Fire up the ULS viewer and see what the correlated error is saying. Oct 16, 2013 at 14:23

1 Answer 1


I find it helps to use an excel spreadsheet when dealing with formulas for calculated columns.

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.