Using join/collect to return task description when task is complete

Hi,

I am trying to create a formula that returns a collection of tasks descriptions when the task is marked as 100% complete. The overall goal is to show, per project phase, what tasks have been completed to date.

Here's what I have currently: =JOIN(COLLECT({Project Plan - EOL Asset Enterprise Range 1}, {Project Plan - EOL Asset Enterprise Range 4}, 1){Project Plan - EOL Asset Enterprise Range 5},",")

Project Plan - EOL Asset Enterprise Range 1 = project task names w/in the phase

Project Plan - EOL Asset Enterprise Range 4 = Task completion

Project Plan - EOL Asset Enterprise Range 5 = project task names w/in the phase

Am I on the right track here? I'm getting an Unparsable response.

Answers