I have a table where the columns are dates and the rows are particular groups. Each cell shows an inspection done by that group on that date (pass/fail info). This table is generated in a Google Spreadsheet that references the other imported Google Sheets dynamically, always showing the last 5 weeks.
What I’d like is when a user clicks on the cell, it takes them to the inspection done by that group on that day. This way they can easily see the details of why that inspection failed on that particular date.
I have a lot of vague ideas on how to do this by reading other topics, but could still use a push in the right direction.
Any advice or guidance would be great! Thanks.