Report- Date filter for WorkDays only

Kim Jones

I have created a report that gets sent to data entry specialists every morning. The report is set to only pull data and only send if there is an entry with a submission date in the last 1 day. In the report I am using the WHEN? filter and have it set as Date is in the last 1 day.

This logic fails on Mondays because data is never added on Sat or Sundays. The problem is that I will be missing data from Fridays since Monday's report only shows the day prior.

Does anyone know if there is a way to set workdays on a grid sheet and report? I know how to set work days for a project but this report is running from a basic sheet and not a project.

Paul Newcome

You could use a formula on the source sheet to check a box based on the date for which rows should be included in the report. This would allow you to show Friday's rows on Monday. Then your report could be built to pull rows where the box is checked.

Paul Newcome

You could use a formula on the source sheet to check a box based on the date for which rows should be included in the report. This would allow you to show Friday's rows on Monday. Then your report could be built to pull rows where the box is checked.

Kim Jones

Thanks!

Paul Newcome

Happy to help! 👍️