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...


Sherry Fox

Data Science & Reporting Specialist | PA Performance & Data Insights

UnitedHealth Group | OptumRx

EAP | Mobilizer | Automagician | Superstar | Community Champion

https://www.linkedin.com/in/sherryfox/

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!