3w1h Format In Excel Link

| Task ID | What | Who | When | How | |---------|------|-----|------|-----| | T001 | Bug in login form | John Doe | 06/01/2026 | Rewrite validation script | | T002 | Missing backup | Sarah Lee | 06/03/2026 | Configure automated job |

This is your source link.

In Dashboard A4, enter:

=FILTER(tbl3W1H[[Task ID]:[How]], tbl3W1H[Who]=B1, "No tasks")

This spills the entire 3W1H record for the selected "Who". 3w1h format in excel link

| Cell with Link | Who | What (Target) | When (Last Check) | How (Purpose) | |----------------|------|----------------|--------------------|----------------| | A1 | Ops | \\server\data\prices.xlsx | 2025-04-01 | Power Query – daily refresh | | B3 | IT | https://api.example.com/stats | 2025-03-28 | Web import – manual refresh | | Task ID | What | Who |

Now let’s build a Dashboard sheet that reads from the master and allows filtering. This spills the entire 3W1H record for the selected "Who"