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
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives