I am entering the below condition as the validation formula for an attribute in the SP list, but it allows me to enter "innovation" instead of "Innovation", how can I avoid this.
=OR([Asset type]="Innovation",[Asset type]="Communication")
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
Try using the same formula in list validation settings.
If this formula is not working then try using this:
=IF(OR([Asset type]="Innovation",[Asset type]="Communication"), true, false)
,) does not work in formula (I am not sure but it is based on something language or regional settings on your site). So in that case use semicolon(
;) instead of comma(