Text cells merged by TEXTLIST generates partially blank cell

Contributor

Text cells merged by TEXTLIST generates partially blank cell

This item has been identified as an outstanding known issue.

 

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:

  • LENGTH(z) = 0
  • ISBLANK(z) = FALSE (Note: ISNOTBLANK will return TRUE)

As above, there's a discrepancy between the two.

LENGTH tells z has no value while ISBLANK tells z is NOT empty.

 

Workaround
There's several ways to workaround this issue:

  • Surround the TEXTLIST line item with TRIM()
  • Use LENGTH instead of ISBLANK or ISNOTBLANK. ie, to simulate ISBLANK insert formula: LENGTH(z) == 0

If this workaround is not suitable in your use case, please contact Support at support@anaplan.com.

 

---

Internal Reference: CALC-2247