Reports: Is there a way to force specific rows to show


I'd like to create a report that summarizes overdue or at risk work by category. Within my Smartsheet, I have that organized by grouping tasks under different headers. I'd like for the report in continue to include those headers as a way to sort which workstream verticles are falling behind. Is there a way to do this?


  • Samuel Mueller
    Samuel Mueller Overachievers

    @EMAT If I am understanding your question, you could add a helper column and put a column formula something along the lines of

    =parent([column name]@row)

    replace column name with the column of the header that you want to sort by.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!