TEXTJOIN
TEXTJOIN(separator, list)
Joins the values of a column into one piece of text, such as the codes of a task's predecessors separated by commas. Blanks are left out entirely, with no empty gap between separators, and the values come in the set's order: tasks in logic order, then by task code.
Arguments
| Argument | What to give it |
|---|---|
| separator | The text to put between values, like ", ". |
| list | A column read from a set of rows, like Predecessors[Task code]. Any type: a date shows as 2026-01-09, a duration in working days of its own task's calendar, like 5d. An empty list gives "". |
Examples
Formula=TEXTJOIN(", ", Predecessors[Task code])
The codes of the task's predecessors, in one cell.
Formula=TEXTJOIN(", ", FILTER(Predecessors, Predecessors[Status] <> "Complete")[Task code])
Only the predecessors still holding the task up.
Formula=TEXTJOIN(" / ", Assignments[Resource])
The resources on the task, by name.
Formula on WBS rows=TEXTJOIN(", ", FILTER(Tasks, Tasks[Critical])[Task code])
On a WBS row: the critical tasks in the node and below it.
Reach for something else when
| You want | Use |
|---|---|
| How many values there are | COUNT |
| How many different values there are | COUNTDISTINCT |
| Two or three single values joined | the & operator: [Task code] & " " & [Name] |
| One value as text, formatted | TEXT |
Common questions
Where is Excel's ignore_empty argument?
There isn't one: blanks are always left out. TEXTJOIN takes the separator and the list, and nothing else; with three arguments the editor says "TEXTJOIN(separator, list) takes 2 arguments".
The editor refuses this=TEXTJOIN(", ", TRUE, Predecessors[Task code])
What does "TEXTJOIN needs a separator and a list" mean?
The second argument wasn't a list: often a set of rows, like Predecessors. Say which field to join, as in Predecessors[Task code].
=TEXTJOIN(", ", Predecessors)
Does TEXTJOIN remove duplicates?
No: every value is joined, repeats and all.