Formula to link "What" for Task T001: =XLOOKUP("T001", tbl3W1H[Task ID], tbl3W1H[What])
Excel links fail most often not because of technology, but because of broken human coordination.
Now your 3W1H format is consistent and professional.
Excel links fail most often not because of technology, but because of broken human coordination. 3w1h format in excel link
Now your 3W1H format is consistent and professional. Formula to link "What" for Task T001: =XLOOKUP("T001",