0

Alright, looking for some help. I think I am close to the solution, but I could use some help getting it over the finish line. This spreadsheet link is a replicated document of my situation.

GoogleSheet link here

Problem: I am using this formula/query below to get the names of all "team members" associated to a project into one cell (see the Summary portion of the sheet)

=arrayformula(textjoin(" ",TRUE,query($B$5:$C$21,"Select B where C = 'Project A'")))

You can see that this is currently working pretty well. The problem is the hardcoded "PROJECT A, B, C, etc." in the formula. Column F is a query that pulls all the unique projects from Table 1. So when Column F values change due to Column B values changing, my formula above does not automatically adjust for the new value in the cell next to it (I have to go in and manually update "Project A" to whatever the new project name is.

Is there any way around this manual update?

Thanks for the help!

1

1 Answer 1

0

Use string concatenation, like this:

=textjoin( " ", true, query(B$5:C, "select B where C = '" & F5 & "' ", 0) )

2

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.