Ancestor and Checkbox Formula

jess_roberts ✭✭
edited 09/08/22 in Formulas and Functions

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!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!