How do I generate the same information that is entered in the parent, into the children?


I am trying to create a report that displays the parent and the children rows, but the criteria is only based off the parent. For example, each parent and children have statuses. But the parent row is the deciding status, the status that matters. I want to show all projects that have a certain PM assigned, AND if the parents' row status is "X". I want it to ignore what the childrens' status is, but still pull it in the report, and have it under the respective Parent row. I am unsure if I need to create a helper column in the sheet I'm referencing, or if there is a trick to do this within the report configuration.

I hope this makes sense.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!