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