Project Task List Template

Break client projects into tasks with owners, estimates and deadlines, and see each project’s percent complete roll up automatically.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

To Do Lists

Tables

Projects, Tasks

Fields

22

Views

grid, timeline, kanban, calendar, form

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Projects

10 fields · 3 sample rows

  • Projects (Grid)
  • Timeline (Timeline)
ProjectTextClientTextLeadTextStartDateDeadlineDateTasksLink to another tableTask CountCountTasks DoneRollup% CompleteFormulaHours EstimatedRollup
Brand refreshSaffron FoodsIshita30 Oct 202614 Dec 2026Moodboard & references, Logo concepts, Packaging mock-ups3133%48.0
E-commerce siteUrban ThreadsMarcus14 Nov 202618 Jan 2027Product catalogue import, Payment gateway setup200%22.0
Investor deckInternalIshita17 Nov 202627 Nov 2026Market size slide100%4.0
Field details
Project · Text
Client · Text
Lead · Text
Start · Date
Deadline · Date
Tasks · Link to another table
Links to Tasks
Task Count · Count
Tasks Done · Rollup
sum of Is Done via Tasks
% Complete · Formula
IF({Task Count} > 0, {Tasks Done} / {Task Count}, 0)
Hours Estimated · Rollup
sum of Estimate (h) via Tasks

Tasks

12 fields · 6 sample rows

  • All tasks (Grid)
  • Board (Kanban)
  • Gantt (Timeline)
  • Calendar (Calendar)
  • Request a task (Form)
TaskTextProjectLink to another tableAssigneeTextPrioritySingle selectStatusSingle selectStart DateDateDue DateDateEstimate (h)NumberIs DoneFormulaDays LeftFormulaAttachmentsAttachmentNotesLong text
Moodboard & referencesBrand refreshIshitaHighDone30 Oct 20265 Nov 20268.01
Logo conceptsBrand refreshKenjiHighIn progress7 Nov 202622 Nov 202624.003
Packaging mock-upsBrand refreshKenjiMediumTo do23 Nov 20267 Dec 202616.0018
Product catalogue importE-commerce siteMarcusMediumBlocked16 Nov 202629 Nov 202612.0010Waiting for SKU sheet from client.
Payment gateway setupE-commerce siteAishaHighBacklog29 Nov 202619 Dec 202610.0030
Market size slideInvestor deckIshitaHighIn progress17 Nov 202621 Nov 20264.002
Field details
Task · Text
Project · Link to another table
Links to Projects
Assignee · Text
Priority · Single select
High, Medium, Low
Status · Single select
Backlog, To do, In progress, Blocked, Done
Start Date · Date
Due Date · Date
Estimate (h) · Number
Is Done · Formula
IF({Status} = 'Done', 1, 0)
Days Left · Formula
IF(AND({Due Date}, {Status} != 'Done'), DATETIME_DIFF({Due Date}, TODAY(), 'days'), BLANK())
Attachments · Attachment
Notes · Long text

Form view “Request a task” asks for: Task, Project, Priority, Due Date, Notes, Attachments.

Project Task List Template: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates