Parent/grand-parent rows in reports
Hello! I have tried to follow steps in other posts, but my brain cannot figure it out :) Could anyone help me identify the helper formulas for pulling parent cells into a report?
I need to pull in to a report the Goals and Problem Statements for any Projects that are identified as "Must Have". So I am trying to figure out the formulas I would need in the columns Helper 1 and Helper 2 to identify a parent that has any children with "must have" projects.
I am having trouble figuring out how to nest formulas for accomplishing this.
Help Article Resources
Check out the Formula Handbook template!