Bringing Parent Rows into a Report so I can put into a dashboard

I can't figure out how to bring the parent rows into a report. I can build a custom Filter in the Sheet and "Include Parent Rows," but then I can't get it into a dashboard.

Answers

  • Matt Johnson
    Matt Johnson ✭✭✭✭✭✭

    Hi @Chris Harbeson

    One way to mimic parent rows in a report is to add a helper column on the sheet with the formula =PARENT(columnwiththeparent). Then on the report filter off the actual parent row and group the report by Parent column. Depending on what you are doing and how many levels of children you have, that may or may not work for your situation.

    I hope that helps though.

    Matt

    Matt Johnson

    Sevan Technology

    Smartsheet Aligned Partner

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!