Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

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!

Tags:

Best Answer

  • Community Champion
    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.

    1. What is coming up based on a due date filter.
    2. 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

  • Community Champion
    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.

    1. What is coming up based on a due date filter.
    2. 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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions