Excel Link: 3w1h Format In

Now clicking on “Finalize Q3 budget” jumps directly to row 10 in the Budget sheet. Make the responsible person clickable to send an email:

| 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("mailto:john.doe@company.com?subject=Task-001 Update","John (Email)") Now clicking on “Finalize Q3 budget” jumps directly

Use =HYPERLINK("#How_Details!A1","View Procedure") instead of right-click linking. This keeps your formula bar clean. Type 2: External File Links Your “Why” might reference an email or a PDF report. In cell C2 (Why), enter: =HYPERLINK("[C:\Projects\Q3_Approval.pdf]","Open Approval Doc") Type 2: External File Links Your “Why” might

This is perfect for the “Who” component. Dynamic Hyperlinks Using CONCATENATE Let’s say you have 100 tasks, each with a corresponding details sheet. Instead of manually linking 100 cells, use:

Or link to a network drive: =HYPERLINK("\\server\files\RCA_Fishbone.xlsx","View Analysis") Suppose you have a “Budget” sheet. To link your “What” (B2) to the exact budget line item: