Is it possible to make a SharePoint list calculated column so that if value equals to Italy it returns '1', otherwise '0'.

I am using:

=IF([Question 1]= "Italy" , "1", "0")

This always returns "1".

  • Can you show us the screenshot of list data in Question 1 column? Your formula looks fine. Jul 16, 2021 at 13:44

1 Answer 1


Your formula seems fine to me.

=IF([Question 1] = "Italy", "1", "0")

Make sure you have below things correctly:

  1. Set The data type returned from this formula is to Single line of text like:

    enter image description here

Microsoft documentations:

  1. Calculated Field Formulas
  2. IF function


  1. Sometimes comma(,) does not work in formula (It is based on language or regional settings on your site). So in that case use semicolon(;) instead of comma(,).
  • 1
    Ganesh, thanks a million. I had a typo on the formula. Have a great weekend!
    – Jose1978
    Jul 16, 2021 at 14:27

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.