Report- Date filter for WorkDays only
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.
Best Answer
-
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.
Answers
-
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.
-
Thanks!
-
Happy to help! 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives