Hello Community,
I have a layered table where I have a Staff Table that is used to assigned Projects and Tasks.
I am connecting three (3) tables: Projects, Tasks, Staff
In the Projects Table, Staff can be assigned as a Project Lead or as Part of the Project Team
In the Tasks Table, there is one field, "assigned to" for any Staff to be assigned to the Project.
In case a user assigns a task to Staff not already on the Project Team, I have an automation set up to add them. However, when they do, it means that someone who is a Project Lead may be duplicated in the Project Team.
This is an issue because I have a simple count field set up to count the total number of projects they are on