| What (Issue) | Who (Owner) | When (Date) | How (Action) | |--------------|-------------|-------------|---------------| | Server down | IT Team | 05/15/2026 | Reboot & patch |
Excel spreadsheet showing 3W1H columns (What, Who, When, How) with blue hyperlink arrows connecting master data to a dashboard. 3w1h format in excel link
=FILTER(tbl3W1H[[Task ID]:[How]], tbl3W1H[Who]=B1, "No tasks") This spills the entire 3W1H record for the selected "Who". Next to the spilled data: =HYPERLINK("#Master_3W1H!A"&MATCH([@[Task ID]], tbl3W1H[Task ID],0)+1, "🔗 Open") | What (Issue) | Who (Owner) | When
External links (e.g., ='[Q2 Plan.xlsx]3W1H'!$C$4 ) break if the source file moves or is renamed. Prefer internal workbook links. Part 7: Troubleshooting Broken 3W1H Excel Links You see #REF! or #N/A . Here’s the fix: "🔗 Open") External links (e.g.
=HYPERLINK("#'Master_3W1H'!A"&ROW(A2), "View Task "&A2)