nelly olson
New Member
hello,
I have downloaded the Talent 9-box Grid template, but i want to change the axis Performance with Potential and vice versa. Can anybody assist on this?
=IFERROR(TEXTJOIN(","&CHAR(10),TRUE, SORT(FILTER(talent[Candidate],(talent[Performance]=G$8)*(talent[Potential]=$D5)*(talent[Department]=$G$3)))),"") - this is the original formula.
I have downloaded the Talent 9-box Grid template, but i want to change the axis Performance with Potential and vice versa. Can anybody assist on this?
=IFERROR(TEXTJOIN(","&CHAR(10),TRUE, SORT(FILTER(talent[Candidate],(talent[Performance]=G$8)*(talent[Potential]=$D5)*(talent[Department]=$G$3)))),"") - this is the original formula.