3w1h Format In Excel Link May 2026
This links each 3W1H row to an external master data file using a lookup. Links break when files move. Use a helper column to test links:
| ID | What | Why | Who | How | Link to Evidence | |----|------|-----|-----|-----|------------------| | PL-01 | Finalize packaging design | Regulatory requires ingredient changes by Sep 15 | Sarah (Design) | Review 3 mockups, get legal approval | Click to see mockups (links to folder) | | PL-02 | Set pricing | To achieve 35% margin | Finance (Tom) | Run competitor analysis | Link to competitor sheet (internal) | | PL-03 | Train support team | Reduce customer complaints after launch | Support lead (Emma) | Create 10 video tutorials | Link to LMS page (external URL) | 3w1h format in excel link
=HYPERLINK("#" & A2 & "_Details!A1", "Details") This links each 3W1H row to an external