Filtering a Count field


#1

Is it possible to filter the results that are counted in a Count field? Example: “Tasks” table is a list of tasks, with a single select column ‘Stage’ that has values representing what stage of completion a Task is in and a ‘Facilities’ column representing buildings. A second table, “Facilities”, is linked and I want to count the number of tasks for each facility but exclude anything with a ‘Stage’ value of Complete.


#2

You can add an additional formula field that is filled only when the stage is not equal to ‘Complete’. Then use that field for counting in your other table…