Really simple If statement - value if true doesnt work if value if false is ""

Jacinta

Hi I have a relatively straightforward if statement and it works, but not always.

This is my formula and it works,

=IF(COUNT(ANCESTORS()) = 3, PARENT(Responsible@row), "nope")

however if I replace "nope" with other types of values, the whole thing stops working, including the value if true ..

e.g. =IF(COUNT(ANCESTORS()) = 3, PARENT(Responsible@row), "") returns blank whether true or false

And =IF(COUNT(ANCESTORS()) = 3, PARENT(Responsible@row), Responsible@row) returns blank when true, works when false

Christian G.

Hi @Jacinta

That seems to be a bug. Have you made a ticket already?

Christian G.

Hi @Jacinta

That seems to be a bug. Have you made a ticket already?

Jacinta

I have now lodged a bug ticket and I have found a workaround - by creating a column to do the hierarchy count and then running the if statement on that column. very weird.