Name the file: 3W1H_Project_Management_LINKED.xlsx
=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") 3w1h format in excel link
The answer lies in a concept we call the — a dynamic, referential system that connects your 3W1H elements so that updating one cell automatically updates everything downstream. Name the file: 3W1H_Project_Management_LINKED
– Columns A:E (3W1H + ID) Sheet2: Dashboard – Contains FILTER + HYPERLINK as shown above Sheet3: How_Details – Linked from Master’s "How" column (use = Master!E2 ) 3w1h format in excel link