I am hoping someone can come up with a solution for me with a Project Management/Task List I am creating.
I have a Base created for Project Management and within the base is a table of tasks (around 40 tasks) that each individual Project will move through throughout its life cycle.
The way I have this set up currently is to manually enter who the task is assigned to, the start and end dates of the specific task and a lookup to select the task from the task table.
Once the task is complete I will manually change all of the fields (the reason for this and not using automation is even though the tasks are in order, they are not always used on each project and the assignee will be different).
What I need is to be able to move the tasks along the workflow but also save the previous tasks (up to 40 of them) so when we get similar projects we can look back to see how long they have taken for the whole project, who has worked on them and how long individual tasks have taken throughout the Project timeline.
Any ideas? Thanks in advance for any replies.