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?

@Paul Newcome



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!