Google Sheet Weekly Report Troubleshooting
Task 2
Prompt
A fellow account manager has been working on their weekly report for a client, but can’t quite seem to get it working. The individual sheets work, but the Weekly section in the Executive Overview isn’t pulling in any data, even though they copied the formulas over and dragged them across. It looks like the formulas in range B14 to N27 aren’t reading properly, but the dates in Column B look different too. Once you’re able to figure that out, the data needs to match the Weekly sheet, and there should be 15 weeks shown. Please help, and explain your findings.
Bonus
They really want to use periods to show the dates, maybe there’s a way to make it work?
File Link
Here is their report (File > Make A Copy): https://docs.google.com/spreadsheets/d/1nAediTxPONsJwQoWwFwjqSadE51r0LT3_Wv_GGCLo7c/edit
Final Solution
Don’t want to wade through the subtasks?
Inferred Subtasks
Below is a list of tasks derived from the prompt, the relevant text from the prompt, and links to the solutions:
…the Weekly section in the Executive Overview isn’t pulling in any data, even though they copied the formulas over and dragged them across.
- Correct the formula(s) in the Weekly section in the Executive Overview so they pull in the proper data.
…the formulas in range B14 to N27 aren’t reading properly…
- Correct the formula(s) in the Weekly section in the Executive Overview to ensure proper output.
…but the dates in Column B look different too.
- Ensure the dates in Column B are properly formatted.
…the data needs to match the Weekly sheet…
- Verify the values in the Weekly section in the Executive Overview match the Weekly sheet.
…there should be 15 weeks shown
- Extend the Weekly section table in the Executive Overview to 15 weeks.
Bonus They really want to use periods to show the dates…
- Alter the formulas in the Weekly section table to support dates with periods.