Ancestor and Checkbox Formula

jess_roberts

Hello! I'm trying to write a formula that I just can't seem to get right. I've got a project with several ancestor levels that I'd like to report on. I'm close, but I just can't seem to get it. I've added a Parent Row helper column with a check box. I'd like the check box to equal True (checked) if the Primary Column is the ancestor column. That way I can just run a report on the True Boxes.

Ex: I want to be able to run reports only on rows for Task 1, Task 2, and Task 3.

Any help would be greatly appreciated!

Andrée Starå

Hi @jess_roberts

I hope you're well and safe!

Try something like this.

=IF(COUNTIF(CHILDREN(Task@row), >0), 1)

Did that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

jess_roberts

Thanks for the quick response @Andrée Starå . Unfortunately, it did not. It's not updating the checkbox to true.

Andrée Starå

@jess_roberts

Happy to help!

Strange! It works on my sheet.

I'd be happy to take a quick look.

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

jess_roberts

@Andrée Starå I shared a test workspace with you. I very much appreciate your offer to help!

jess_roberts

@Andrée Starå I think I'm getting closer, but I'm not quite there yet. I've edited the formula above and started something like this:

=IFERROR(INDEX(ANCESTORS(Task@row), 1)

But after that, I'm stuck. I need the check box to appear checked if True and unchecked if False.

Any ideas?

Thanks!!!