3w1h Format In Excel Link -

| 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) |

| Component | Question Answered | Example (Marketing Campaign) | |-----------|-------------------|-------------------------------| | | What needs to be done? What is the problem or objective? | Launch a Q3 social media ad campaign. | | Why | Why is this important? What is the business value or root cause? | Increase brand awareness by 20% and generate 500 leads. | | Who | Who is responsible, accountable, consulted, or informed? | Marketing manager (lead), graphic designer, copywriter. | | How | How will it be executed? What are the steps, methods, or resources? | Create 10 ad variants, A/B test on Meta, allocate $5k budget. | 3w1h format in excel link

=HYPERLINK("#Budget!B10","Check Budget Item") | ID | What | Why | Who

Where A2 contains the task ID (e.g., TASK-001). Then name each sheet TASK-001_Details . Excel will dynamically construct the link. Convert your range into an Excel Table ( Ctrl + T ). Then add a new column called “Linked Evidence”. Formula example: =HYPERLINK("[MasterData.xlsx]Sheet1!A" & MATCH([@ID], MasterData[ID],0), "Evidence") | | Why | Why is this important

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:

=HYPERLINK("mailto:john.doe@company.com?subject=Task-001 Update","John (Email)")

=HYPERLINK("#" & A2 & "_Details!A1", "Details")