Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
Hi,
We have quite a long project happening. We would like to know if it's possible to show the Gantt chart view with weeks for 2017 and quarters or years for 2018/19. Is there anyway of doing this?
Hope this makes sense!
Fiona, none that I can think of in just one sheet but it might be worth experimenting with adding a Report with Gantt that will give you that telescopic view for future years?
Hope that helps
RichardR
Hi Richard,
Would this mean printing off 2017-18 on the original sheet and then doing a report for subsequent years?
Fiona
I am defintely not recommending priniting anything off when you can have Real Time Reports on your screen.
What I suggest is you create a Report, that by date selection focuses on the short term, then another Report that selects the longer term period. in the second Report use the settings area (top left in Gantt window) to choose Quarters or even years, so you Gantt bars will give you the telescopic view what you seek.
Plus you can Publish those Reports and send a link to "View only colleagues", who want the big picture, but you dont want them changing anything.
While your editors would be shared to the master sheet and those Reports so they CAN make changes.
If you are not already familiar with Reports then review this...
https://help.smartsheet.com/articles/522214-creating-reports
Hope that helps?
Richardr
