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 on the master grid. I can’t figure it out for the life of me. Can anyone help?
TEXTJOIN(” • “,TRUE,IF(‘Master Grid’!K187:K288=”x”,’Master Grid’!$AL187:$AL288,””))
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 on the master grid. I can’t figure it out for the life of me. Can anyone help? TEXTJOIN(” • “,TRUE,IF(‘Master Grid’!K187:K288=”x”,’Master Grid’!$AL187:$AL288,””)) Read More
