Google Sheet Weekly Report Troubleshooting - Subtask 4
Description
…the data needs to match the Weekly sheet…
- Verify the values in the Weekly section in the Executive Overview match the Weekly sheet.
Solution
Visually compare the Executive Overview and Weekly Overview tables.
Explanation
For larger tables, it might be necessary to implement something like conditional formatting or vlookups to identify mismatched values. Because these tables are small, it’s easy to simply compare them row by row for any discrepancies.
Comparing the two tables we see the date in Executive Overview B24 is 9/2/2020 while in the Weekly Overview table it’s 9/5/2020. Counting by weeks, the correct date is 9/5/2020. The values in the remaining rows appear to match.
We also see some formatting discrepancies for columns J Revenue and K ROAS. According to the Weekly Overview table Revenue should be formatted as currency and ROAS as percentage.
As you’ll see in Subtask 5, we’ve addressed all these issues.
10/31/2020 and 9/12/2020. We’ll address that in Subtask 5 as well.