Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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?

TIA

share|improve this question
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.