Report showing Yesterday's form submissions, only if not a weekend
I've got a report showing form submissions from YESTERDAY, but on Mondays, the report will be blank. I need it to show the previous work day's submissions (it calculates an average daily score).
Is it possible to filter this report to show the last WEEKDAY's submissions?
Answers
-
I noticed that by using the filter "Date is in the last 1 days", it also brings in today's submissions. How can I make this report show only the previous work day's submissions (Date column = last week day)
-
Hmm you could try creating a checkbox column and enter the following formula:
=IF([submission date]@row = workday(today(), -1), 1, 0)
Then in your report, filter based on whether that checkbox is checked to display whatever was submitted the last working day. Would that work for what you're trying to do?
-
I would make the same suggestion as @kioshi43
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!