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".
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
Your formula seems fine to me.
=IF([Question 1] = "Italy", "1", "0")
Make sure you have below things correctly:
,) 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(