June 01, 2012

Calculated column Formula supporting Maximum number of IF ELSE statements and workaround for syntax error

Hi SP Folks,

One of the user got requirement with colour coding to a list view based on the values selected. so created a calculated columns to achive this functionality. but user experienced error after choose to go with extra color codes (which will extend the Furmula conditions) as:

"Calculated column sysntax error OR not supported", but formula syntax looks fine. After investiagtion

the calculated column supports only 7 levels of IF ELSE conditions in the formula, after that it will through above error. so after googling found solution HERE, and can be achivable by CASE statement as HERE(but i didn't try this)

the output result: