Weekend recap?
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.
Answers
-
Are you able to provide a manually mocked up example of what you are wanting to automate?
-
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?
-
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.
-
Dynamic View is not going to solve your struggles. Is this report coming directly from a sheet?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!