Forum Discussion
CCCAJen
Jun 14, 2024Copper Contributor
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...
- Jun 17, 2024
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.
CCCAJen
Jun 17, 2024Copper Contributor
I saved a copy of the two tabs. However, the formulas in the "Seminars by Core Discipline" are still pulling from the original document. But you should be able to at least see the content it's supposed to be pulling from and see if there's something wrong with the rows in the master grid tab. Thanks!
HansVogelaar
Jun 17, 2024MVP
Try
=TEXTJOIN(" • ",TRUE,FILTER('Master Grid'!$AL187:$AL288,'Master Grid'!S187:S288="x",""))
- CCCAJenJun 17, 2024Copper Contributor
I tried that, and it just removed the "0"s that were showing up in the list. But it's still not pulling in the actual data from the master grid.
At the top of the master grid it says to not use "shift cells up" or "shift cells down" if adding new rows. Is it possible that someone did that and it's causing this issue?
- HansVogelaarJun 17, 2024MVP
The formulas look at rows 187 to 288 on the Master Grid sheet. If you want to include data from rows higher up, you'll have to change the starting number 187 in the formulas.
- CCCAJenJun 17, 2024Copper Contributor
HansVogelaar One of the rows it is supposed to be pulling from is 211, so it's well within the range.