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.