Add Parent Task to Report

josedimaculangan
josedimaculangan ✭✭
edited 05/03/24 in Smartsheet Basics

How do I add the Parent Task to this report? I need the Green rows on this report.

image.png


image.png

Answers

  • Jgorsich
    Jgorsich ✭✭✭✭✭

    Your images aren't loading for me, so I can't give you specifics. However, when I've run into similar problems it is because I'm filtering the report using criteria that simply excludes the parent rows. My work around has been to add a hidden column that allows for inclusion of the parent cells and then filtering on that column instead (even without displaying it).

  • josedimaculangan
    josedimaculangan ✭✭

    Thanks @Jgorsich turns out it was an easier fix than I thought. Just select more options for the Hierarchy field.

    image.png
  • Jenn504
    Jenn504 ✭✭

    @Jgorsich I am trying to import an excel file into smartsheets without losing formatting or formulas- I've read on another forum topic that you might have experience with this?