Displaying Upcoming Tasks in a Dashboard
Hello,
I'm currently exploring the most effective approach for showcasing upcoming tasks scheduled for the next month. The data is organized into three columns on a report (but I have sheet access to the data too): the first column indicates the month of publication (with a subheading or nested section specifying the task to be published), the second column contains the project names, and the third column displays the exact publishing dates.
For confidentiality reasons, the actual names of the tasks have been redacted in the image below.
I am required to present the information neatly and visually on a dashboard, I am considering alternatives beyond a traditional Gantt chart. I want a chart that shows what was published last month, and another to show what is upcoming in the next month. Could you provide suggestions for suitable ideas or functions that I should consider for this purpose?
Thank you very much in advance!
Best Answer
-
Hi @FatAtty,
I do the same with a project dashboard where I show tasks that are due in the next 14 days, as well as those completed in the last 14 days.
I do this by having two reports that show.
- What is coming up based on a due date filter.
- What has happened based on a completed date filter.
Please note that these reports are row reports and not summary reports.
Within the Dashboard I then add a report widget and link it to the corresponding report.
John
Answers
-
Hi @FatAtty,
I do the same with a project dashboard where I show tasks that are due in the next 14 days, as well as those completed in the last 14 days.
I do this by having two reports that show.
- What is coming up based on a due date filter.
- What has happened based on a completed date filter.
Please note that these reports are row reports and not summary reports.
Within the Dashboard I then add a report widget and link it to the corresponding report.
John
-
Thank you so much for your help John! that is so useful!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 459 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 137 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!