Report showing Yesterday's form submissions, only if not a weekend

Kylie Jones

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?

@Paul Newcome

Kylie Jones

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)

kioshi43

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?

Paul Newcome

I would make the same suggestion as @kioshi43