How do I join multiple rows of texts into one cell based on another column's criteria?
Above is a screenshot of the sheet I'm currently working with.
In each cell of the third column, "List of Tasks", I want to enter a formula that will join all of the text in each row of the "Tasks" column but only include text whose row 2, "Task Completed", states "No". I know how how to use the join function, but not if I'm incorporating a certain criteria. Would I have to use a "collect" formula inside of the join formula? What would this look like?
Also, when I do join the text, I want the delimiter to be an "enter" value instead of just a typical space, dash, or comma. Is this possible? I think in Excel you can use "Ctrl + J" to designate "Enter" but I can't seem to get it to work here.