Jan 01, 2025 04:12 AM
I have a table with a count field that is supposed to count the number of linked records in another field that meet certain conditions. For some reason, the count field is not properly filtering the conditions and is counting ALL linked fields. I am not sure why this is happening as I have set this up properly. I have checked off "Only include linked records from X table that meet the following conditions" where "Status" has any of "X, Y." It is still counting fields where the status is not X or Y.
Does anyone know why this might be happening and how to fix it?
Jan 01, 2025 02:56 PM
Hey @dbavli!
Would you mind sending a screenshot of your Count field and how the condition has been set?
Please make sure that the condition is set in the count field -not in the linked record field (such condition on the linked record field achieves a different outcome).
Jan 01, 2025 04:42 PM
As a data point, it seems to be working fine for me: