Turn a plain task list into a formula-driven Gantt chart in Google Sheets or Excel, with workday-based dates, dependencies, conditional-formatting bars and the critical path flagged. No add-ons or macros.
What you get
- A prompt that orders tasks so every predecessor sits above its successors
- A table layout with ID, task, owner, duration, predecessor, start, end, late finish, late start, float and critical columns
- Exact formulas for start, end, late finish, late start, float and critical flags, ready to fill down
- A timeline row and conditional-formatting rules that draw the bars and highlight critical tasks
- Support for non-working days and holidays
- Notes on adjusting formula syntax between Sheets and Excel
Who it's for
Project managers and team leads at an intermediate level who want a real schedule in a spreadsheet they already use, not another project tool.
Works with Claude, ChatGPT and other AI chats.