Find Parent that is not blank or row with no children

Ferdi Retief

How do I find whether a cell is a parent and not blank?

I have tried

=IF(AND(NOT(ISBLANK(Description@row)), COUNT(CHILDREN(Description@row)) > 0), 1, 0)

which gives me the parent and not blank, but it does not give me rows that do not have any children.

I need rows that are parents and not blank + rows that do not have children and are not blank

Appreciate your help

Find more posts tagged with

Formulas

functionality

Accepted answers

All comments

Paul Newcome

How many different hierarchy levels do you have?

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.