Threaded Comments vs. Notes for Clean Workbook Feedback
Know when to start a threaded @mention review conversation with Comments vs leaving static cell documentation using Notes.
Key takeaways while you watch
- Use Comments (Shift+F2 / Ctrl+Alt+M) for threaded reviewer replies, @mentions, and Resolving questions.
- Use Notes for permanent, non-conversational assumption notes (e.g., accounting policy definitions).
- Review all open feedback from Review -> Show Comments before sending a final workbook externally.
Drill: Build an Automated Sign-Off Gate Formula
Write an IF + AND formula for D2 that outputs "Ready" only when Reviewer Status (B2) equals "Approved" AND Open Comments (C2) equals 0; otherwise output "Hold".
| Tab Name (A) | Signoff (B) | Open Comments (C) | Gate Status (D) |
|---|---|---|---|
| Q4 P&L | Approved | 0 | =? |
| CapEx Schedule | Pending | 2 | Hold |
Module 01 Knowledge Check
Answer all 3 questions and check your score to unlock credit toward completion.