SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Not sure what the problem is but when i use the following formula when creating a calculated column

=IF([Event Type]="","Black",IF([Event Type]="PFL","Red",IF([Event Type]="VCL","Gold",IF([Event Type]="HSL","Green",IF([Event Type]="FL3","DarkBlue",IF([Event Type]="FL1","DarkCyan",IF([Event Type]="RPL","DarkRed",IF([Event Type]="MM","Gray",IF([Event Type]="Vacation/Availability","Orange","")))))))))

I get an error "One or more column references are not allowed because the columns are defined as a data type that is not supported in formulas (Event Type is a choice) If I use the same formula but with a one word named column like "Category" it creates it just fine. Ideas?


share|improve this question
up vote 3 down vote accepted

I thought the limit in calculated columns was 7 nested IF statements per branch. You can concatenate several nested ifs to achieve your desired results. Are you using Christophe's color coded calendar tool to generate that? The calculated column looks identical, but I cannot make it generate the orange if, most likely it's bumping into the nested if limit. Look over the first link and see if that helps you out.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.