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
Business Process Analyst 3 | C5ISR Group
HII | Mission Technologies
EAP | Mobilizer | Automagician | Superstar | Community Champion
Original Smartsheet Profile: @Sherry Fox
Answers
-
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.
-
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.
Sherry Fox
Business Process Analyst 3 | C5ISR Group
HII | Mission Technologies
EAP | Mobilizer | Automagician | Superstar | Community Champion
Original Smartsheet Profile: @Sherry Fox
-
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)?
-
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.
Sherry Fox
Business Process Analyst 3 | C5ISR Group
HII | Mission Technologies
EAP | Mobilizer | Automagician | Superstar | Community Champion
Original Smartsheet Profile: @Sherry Fox
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!