Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 06, 2023 12:41 AM
The bottom one should be a count of 2. Team A and Team B are two fields. I tried COUNT, COUNTA, COUNTALL
Here's the formula
I can't even add a Count to that specific field
Thanks
Solved! Go to Solution.
Feb 06, 2023 04:20 AM
Duplicate the Team Splits field and turn that new field into a Rollup, then use the COUNTA function in the Rollup.
Feb 06, 2023 04:20 AM
Duplicate the Team Splits field and turn that new field into a Rollup, then use the COUNTA function in the Rollup.
Feb 06, 2023 05:55 PM
Yeah it's a weird one sigh. A possible solution could be to add a `Count` field to the junction table you've got, and then adding a rollup field on your main table with a `SUM(values)`?
Feb 07, 2023 08:47 PM
This worked like a charm! Thank you both for your suggestions.