Result from ISNOTBLANK() is not aligned to LENGTH()

Question

Hi Anaplanners,

I have encountered this super weird situation where I am using ISNOTBLANK() formula to identify if there's any characters in my Parent Reporting Sub-Segment (PRSS) column, but some rows (see ss below) is showing ISNOTBLANK() = TRUE even when there's no inputs. When I tried to troubleshoot this with LENGTH() formula, all the length() for the PRSS column are 0. I ultimately resolved this issue using TRIM() in PRSS column. Does anyone have insights on this behavior? Is this an Anaplan bug?

SanthoshS · Accepted Answer

Yes, it seems like a known behavior check here. And you handled it well already by using TRIM()