Display Tasks for the week

I have a project plan that has tasks and due dates each week. I am using a report to put this week's tasks on a dashboard. However, I am only able to use the filter on Due Date in the next 5 days and/or in the past # days. As they go through the week, this will end up showing them tasks that may be due next week. I want this report to show the current calendar week, no matter what day of the week the user looks at the report.

Is this possible?

Best Answer

  • Sam M.
    Sam M. ✭✭✭✭✭
    Answer ✓

    Hi @Andrea Westrich ,

    I think this might work for you.

    You can add another column to the sheet that has this formula:

    =IF(WEEKNUMBER([Due date]@row) = WEEKNUMBER(TODAY()), "This week", "-")


    Then on the report you can filter by that column:

    Hope it works for you,