Count of Specific Value in Another Table

[mendozacardinal]

I am tying to count a specific quantity in a table that references a value from another table column.  

For example, one table has a list of project names and another table a LONG list of various tasks that reference the associated project. I am trying to find the right formula to count the number of tasks per project into the project table.

[dbaum]

COUNT([Related Tasks])

[mendozacardinal]

I was trying this, referencing the column (PROJECT ID) in another table (PROJECT TASKS) which equals the PROJECT ID in the PROJECT LIST table.

COUNT(SELECT(PROJECT TASKS[PROJECT ID])) = [PROJECT ID]

[mendozacardinal]

I was trying this, referencing the column (PROJECT ID) in another table (PROJECT TASKS) which equals the PROJECT ID in the PROJECT LIST table.

COUNT(SELECT(PROJECT TASKS[PROJECT ID])) = [PROJECT ID]

[Jean_Paul · Accepted solution]

Maybe You can try something like this: 

count(select(PROJECT TASKS[PROJECT ID],[PROJECT ID]=[_THISROW].[PROJECT ID]))