Trying to make lists of people and group them, but can't seem to figure out the right syntax to do this with in formula for Structure.
What is wrong with the formula here?
ARRAY1 = ARRAY((assignee = j.j), (assignee = a.m), (assignee = c.p))
ARRAY2 = ARRAY((assignee = j.k), (assignee = t.m), (assignee = m.m))
ARRAY3 = ARRAY((assignee = c.s), (assignee = c.s), (assignee = a.b))
IF(SEARCH("C", ARRAY1), "Engineers", SEARCH("B", ARRAY2), "Artists", SEARCH("A", ARRAY3), "Designers")
