Hello I am working on adding some information to a dashboard. I want to show locations that are closed on certain days. I created a report called Center Closed hours and included the correct columns from the main sheet. I set up the filter to say if Monday Open is equal to CLOSED, Monday Closed is equal to CLOSED etc. The goal was to get this report to show the centers that are closed on certain days. Here is the screen shot, any ideas?
Help Article Resources
Check out the Formula Handbook template!