Issue with Array formula that interacts with a calculated column

Hello all,

I have an array formula I am using to populate a dashboard based on project status (column L) in another tab. The formula is:

{="● "&TEXTJOIN(CHAR(10)&"● ",TRUE,IF('Master Project Plan'!$L11:$L200="Upcoming",'Master Project Plan'!$E11:$E200,""))}

If the cell(s) in column L are hardcoded, the formula works fine, however, in normal practice, Column L is a calculated field based on project start/due dates.

If the status is hardcoded as "Upcoming", I see my desired result, but if the status is "Upcoming", but comes from the formula, I get no results in my array.

Can you have an array formula that works with a calculated field?

Thanks in advance for looking at this.

There is no reason for it not to work so long as it is actually giving the correct string.

Check the formulas in column L, do they have "Upcoming" hardcoded in them? If not trace the formulas back to the point where "Upcoming" is hardcoded and look for any stray spaces, also check each formula in case a space is being added to "Upcoming", for example, a formula containing &" "

"Upcoming " is not the same as "Upcoming"

Depending on the source of the hardcoded string, it could even be a no breaking space, which can be harder to find.