disclaimer

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 are two possible ways to work around 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 these workarounds are not suitable in your use case, please contact our Care team.