Gantt Chart in a Spreadsheet
Visualize timelines with formulas.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
Build a Gantt chart that updates from a task table in a spreadsheet. Project and duration: [PROJECT_AND_DURATION]. Tasks and dependencies: [TASKS_AND_DEPENDENCIES]. Spreadsheet app: [SPREADSHEET_APP]. Team: [TEAM]. Design it and check each item as you go: [ ] Task table columns: ID, Task, Owner, Start, Duration (working days), End (formula, excluding weekends and a holiday list), Predecessor, Percent complete, Status [ ] Start date formula that can depend on the predecessor's end date plus one working day, with manual override flagged [ ] Timeline grid across the top with dates or weeks generated by formula from the project start [ ] Conditional formatting that fills cells where the date falls between the start and end, a different color for completed portions, and a line for today [ ] Milestones shown with a distinct marker [ ] Critical path guidance: how to mark the longest dependency chain [ ] Summary rows for phases [ ] Check cells for broken dependencies and tasks without owners [ ] Data validation for status and owner [ ] Print setup for one-page view Provide the formulas for my app, the conditional formatting rules written precisely, and a sample of ten tasks with expected dates to test. Add a weekly update routine and a way to track baseline versus current dates.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.