Use the new Insert > Checkbox feature (available in Microsoft 365) in a "Done" column for a modern, interactive feel.
Once your raw 3W1H data is in place, use Excel's native automation tools to make the spreadsheet dynamic and error-proof. Data Validation (Drop-Down Lists)
Assigning multiple people to the "Who" column dilutes accountability. If multiple people are involved, break the task down into sub-tasks. 3w1h format in excel new
Modern Excel updates introduce dynamic array formulas and advanced formatting features that make setting up a 3W1H framework more automated than ever before. The Anatomy of a 3W1H Excel Sheet
Instead of writing "Marketing," write "Drafting 3 social posts for LinkedIn." Use the new Insert > Checkbox feature (available
Let's build a modern 3W1H format using Excel’s latest features (Microsoft 365 or Excel 2021/2024).
It instantly generates a new 3W1H table showing only what John owns, why he owns it, and how he is progressing. This is the "new" way to review workload. If multiple people are involved, break the task
In column F, use: =TEXT(IF(F2<=0, "Not started", IF(F2>=1, "Complete", TEXT(F2,"0%"))))
Populate the table with the relevant information. For example, let's say you're tracking sales data: