I'm Desperate. Can anyone help build this formula? I've been stuck for approximately 60 hours.


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!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!