This item has been identified as an outstanding known issue.
z = TEXTLIST(x, y, n, [d])
Syntax taken from Anapedia
When using TEXTLIST formula and all source cells ("x" in above formula) are blank, the resulting cell using the 2 formulas below on "z" will have the following characteristic:
As above, there's a discrepancy between the two.
LENGTH tells z has no value while ISBLANK tells z is NOT empty.
WorkaroundThere's several ways to workaround this issue:
If this workaround is not suitable in your use case, please contact Support at email@example.com.
Internal Reference: CALC-2247