Weekend recap?

smcliman

Hi,

I work in operations and it is 24/7. We have report out metrics that we use a smartsheet form to capture twice a day everyday.

I need a report structure/sheet/cell formula to display metrics from only the weekend days in a year to administration folk that only work M-F.

I have tried a workaround with =DATE(YEAR(TODAY()), MONTH(TODAY()), 30) and then another column with 0-30 to calculate current date in a month, but i cant seem to figure out a way to only have it calculate weekends as the date changes for every month.

I only need to display data from the most recent weekend that has passed on monday morning. The metric is displayed on a dashboard and would like to keep it a permeant fixture and just display "N/A" if its not a weekend.

Open to any and all suggestions that will only calculate weekend date numbers in a year. If its not perfect thats fine I can find a work around.

Paul Newcome

Are you able to provide a manually mocked up example of what you are wanting to automate?

smcliman

So this is a report showing the most recent entry for three different functional areas within the company. Everyday there will be three separate entries. This current report is great for displaying data during the work week when management/administration staff are working M-F. However, come Monday morning, there are three days worth of data that need to be displayed for a weekend review when they are not here.... Having two separate reports doesn't really work with how many different reports there need to be displayed (i.e safety, quality, staffing, vacation, etc) Im wondering if this is something dynamic view might be able to solve?

smcliman

Also, i was able to get the WEEKDAY function to work correctly, but it still doesnt provide a dynamic report view to encapsulate those times. If it isnt possible then thats fine i just figured it was worth asking or if dynamic view is what i should be looking into.

Paul Newcome

Dynamic View is not going to solve your struggles. Is this report coming directly from a sheet?