Forum Discussion
Solved
TextJoin returning 0 values despite content being in the originating field
I have a formula that is pulling in correct data except for a few lines in my "master grid." (See formula below) For some random lines, it pulls in "0" instead of the text that is in the fields o...
The formula concatenates values from column AL:
=TEXTJOIN(" • ",TRUE,FILTER('Master Grid'!$AL187:$AL288,'Master Grid'!S187:S288="x",""))
The text "Leading through conflict is in E211, not in AL211. That's why the formula doesn't return it.
HansVogelaar One of the rows it is supposed to be pulling from is 211, so it's well within the range.
Can you provide an example of a cell whose formula doesn't return the information you expect, and indicate what is missing?
- Thanks HansVogelaar. I have no idea how the formula was working fine for every other column on that tab, but I changed it to E instead of AL. Now it just pulls in the title, not the title and speaker name. But I can work with that, as long as it's returning all the titles it should. I appreciate your help!
The formula concatenates values from column AL:
=TEXTJOIN(" • ",TRUE,FILTER('Master Grid'!$AL187:$AL288,'Master Grid'!S187:S288="x",""))
The text "Leading through conflict is in E211, not in AL211. That's why the formula doesn't return it.
- HansVogelaar if you look at the document I uploaded and look at row 211 on the master grid tab, there's an X in column S. The formula on the other tab under column K in row 6 should be listing the title "Leading Through Conflict" and the speaker "Steve Garcia" but instead it only shows a 0.