Automating Report to update to "This Week"?

Is there an option in Report Filters to always have the report update to show items due within This Week (preferably Mon-Sun)?

Answers

  • Leibel S
    Leibel S ✭✭✭✭✭✭

    @Callie Langford

    Add a column on your sheet and run the report filter using this column (where checked)

    =IFERROR(IF(WEEKNUMBER([Due Date]@row) = WEEKNUMBER(TODAY()),1,0)

    The above would not check against year... I assume you have other filters to block something that was already completed... and if something was not completed a year ago you probably want to know about it :)

  • Thank you, great approach but I'm currently getting an #UNPARSEABLE error when applying that to check my Due date column.

  • Leibel S
    Leibel S ✭✭✭✭✭✭

    Woops, made an edit within the community and did not get it right.

    See below revised:

    =IFERROR(IF(WEEKNUMBER([Last Comment Date]@row) = WEEKNUMBER(TODAY()), 1, 0), 0)