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

Find more posts tagged with

Accepted answers

Christian G.

Hi @Jacinta

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

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.