We have a task list with a column that categorizes tasks into one of 12 categories. We're trying to calculate a NEW column that will be populated with one of two values, "Technical" or "Procedural" based on the category.
I can create the column without any difficulties, but keep getting syntax errors when trying to add that column to my site columns.
I'm using nested ifs (=if([category]=condition1),"someValue1",if([category]=condition2),"someValue2",if([etc....) to achieve this but am trying to test with a single if-then, which is also returning syntax errors when I try to add the column to the site.
I suspect I have a misplaced paren/bracket/quote.
=if(([IssueCategory]="Question for IT"),"Technical","other");
Can anyone tell me why this is returning as a Syntax error?