Formula does not appear to be working

Okay, first, here is my formula:

=IF([Release Name]@row = "", "", IF(COUNT(ANCESTORS()) = 0, 1))

It is in the far right (second image) in the column named Is Parent, which is a checkbox. I only noticed this issue as a result of checking on these release numbers that are a variation of the same number with letters as a "suffix". What concerns me is there can easily be more. This is set as a Column Formula in the Is Parent column. This sheet has over 2400 records, and will soon have a lot more, so I need to be confident that this is correct.

New: Release Update Sheet

on the same sheet, to the far RIGHT, the same rows show...

Find more posts tagged with

Sheets

Formulas

functionality

Accepted answers

All comments

Paul Newcome

Try a cell reference in the ANCESTORS function that references a column that will never be blank on any row. If you need to flag all parent rows and can have multiple hierarchy levels, my recommendation is to count children instead of ancestors to flag parent rows.

Sherry Fox

https://community.smartsheet.com/discussion/comment/419338#Comment_419338

@Paul Newcome ,

The Release Name column, which is being referenced, is ONLY empty until a new record is added. I want that field (Checkbox) to be blank, if there is no release name listed.

Paul Newcome

I understand that, and you have that accounted for by the first part of the IF. Maybe I am misunderstanding the issue. What exactly is happening that shouldn't be happening (or isn't happening that should)?

Sherry Fox

@Paul Newcome ,

As shown in this image these items SHOULD be checked as they are parent rows, but they are not. I have circled the Parent rows that should be checked. As shown in my original post, the child rows are indented as they should be. However, sometimes this works (as in the first one) and other times it doesn't (like the second 2). And this is a column formula.

Paul Newcome

Ok. Then I go back to my previous suggestion. Try a cell reference inside of the ANCESTORS function to reference another column that will not be blank.

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, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.