Formula to add automatic project name & filter by project name

Hello I have 2 tables one with projects and one with all project tasks, what I want to do is when creating a new project and adding new tasks to the project, I want to populate the project name on each task so when I open the Project Row all the tasks realted to that project can be filtered.


The filter I would like to have it in the template so every time you create a new project all the tasks that you add will be filtered.

Victor, can you share your document so we can collaborate on it?

I manage to do the first step, adding the Project name to the tasks, now what I want to do is to filter in the template, to just show the tasks that are for that project.

I am not sure if this is what you need but please see below:


this is for automatically populating the task column in the all projects tasks table (by using the completed task on the project table)


this is for automatically populating the project owner column in the all projects tasks table (by using the value entered in project lead)

2 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.