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")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.