Report using quarters
I would really appreciate if someone could please advise how do I create such a report- we use quarters instead of dates (not specific in our industry, as in- we cannot provide specific dates) for product timelines. I would like for the report to automatically pull data from project data sheet and if possible also apply project status color coding (how would I do that?).
Thank you.
Answers
-
Hi @Ildze
If you could use dates as place holders just so the Gantt chart can be visible, then you're almost there by zooming way out on the Gantt View.
As for the Peak Sales and POS Peak %, it would probably work best having them just to the right of the End Date, before the Gantt, on the sheet/report itself.
I'm not sure that will work, given the no dates thing, but it's an option.
Matt
-
Many thanks Matt for your answer, I appreciate it you taking the time and offering your solution. Unfortunately providing dates would be too much to ask in this case to the team, as it is not just one but 3 columns and then the file will be overpopulated and overcomplicated.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives