How to keep your gantt chart from getting too big

04/08/21
Answered - Pending Review

Hi all,


I am creating a gantt chart in smartsheet and I was wondering if there is a way from dates that are older than 60 days to disappear from the sheet to stop it getting too big? Maybe by some form of automation, filtering or something else?


I have tried doing it in filtering and the problem is that the parent row stays pinned on the earlier date even if the child row disappears. If you include parent rows in the filter then the parent row disappears as well.


I need a way to make the parent row adjust to the new earliest date but have child date rows that are too old disappear.

Answers

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi @Sook Wern Chua

    I hope you're well and safe!

    You could set up a Workflow combined with the Move Row feature to move the rows automatically.

    Would that work/help?

    I hope that helps!

    Be safe and have a fantastic week!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.