Automating Report to update to "This Week"?

Callie Langford

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

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 :)

Callie Langford

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

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)