CASE(Jira_Status__c,
"Backlog","Not in Dev",
"Blocked","Not in Dev",
"Canceled","Not in Dev",
"Discovery","Not in Dev",
"New Request","Not in Dev",
Until I got to about line 44. Then I kept getting a syntax error stating the line was missing a )
If I removed the line that was highlighted, the error would show on the next line.
Until I removed everything up to NULL, then it was fine. But then I am missing about 15-20 lines of data.
Is there a way to consolidate this somehow? We have about 25 statuses that become "Not in Dev". When I copied the entire formula into word, the count was 1229 so I am not sure why I cannot save the entire thing.
Thanks in advance!
6 respuestas
You're missing a bunch of commas after "Work in Progress","In Dev",
CASE(Jira_Status__c,
"Backlog","Not in Dev",
"Blocked","Not in Dev",
"Canceled","Not in Dev",
"Discovery","Not in Dev",
"New Request","Not in Dev",
"On Hold","Not in Dev",
"Open","Not in Dev",
"Pending","Not in Dev",
"Pending Customer","Not in Dev",
"Postponed","Not in Dev",
"Quoted","Not in Dev",
"Ready for Dev","Not in Dev",
"Request","Not in Dev",
"To be scheduled","Not in Dev",
"To Do","Not in Dev",
"Triage","Not in Dev",
"Assigned","In Dev",
"Code Review","In Dev",
"Completed","In Dev",
"Dev Assigned","In Dev",
"Dev Complete","In Dev",
"Dev Triage","In Dev",
"Documentation","In Dev",
"In Development","In Dev",
"In Progress","In Dev",
"In QA","In Dev",
"In Review","In Dev",
"In Testing","In Dev",
"QA Ready","In Dev",
"QA Test","In Dev",
"Ready for MR/QR","In Dev",
"Ready for Testing","In Dev",
"Ready for QA","In Dev",
"Ready for Release","In Dev",
"Ready for Review","In Dev",
"Reopened","In Dev",
"Resolved","In Dev",
"Review","In Dev",
"Scheduled for Release","In Dev",
"Selected for Development","In Dev",
"UA Test","In Dev",
"Work in Progress","In Dev",
"Done","Dev Complete",
"In Production","Dev Complete",
"Patch Release","Dev Complete",
"Published","Dev Complete",
"Released","Dev Complete",
"Closed","No Plan to Fix",
"Rejected","No Plan to Fix",
NULL)
