Weekend recap?


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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!