Sharing Filtered Gantt Charts

Dan Prascher

I want to share a filtered view of a smartsheet (gantt chart enabled) that shows:

 

• dependencies and parent/child relationships that the user can close and open to help them focus on what they want.

 

If I make a report out of it, I loose the parent/child functionality and the dependencies aren't displayed. 

 

I'm resorting to remaking the smartsheet in another smartsheet and linking all the cells from the source sheet to the "display sheet" and giving people access to the display sheet. There's got to be a better way.

Brett Evans

Sounds like saving and sharing filters could help...

https://community.smartsheet.com/announcement/new-saved-filters-search-comment-updatesand-more

 

Dan Prascher

Gotcha, Brett. However, I also need to exclude a bunch of columns (the source sheet has a ton of columns that aren't applicable to everyone). That's why a report is great, but it kills the other functionality.