Help

Help With Counting Rollup Fields

Topic Labels: Formulas
571 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Tom_Blanchard
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi - I am having a heck of a time figuring this out.

I have a table called "Days" that holds different tasks with various dates. Some tasks have the same date.

In a separate table called "Crew", I assign the Tasks to the crew, and can rollup the linked records to only return the unique dates. However, when I try to count these, it adds the tasks up on the same date, even though I only need it once.

Example:

DAYS TABLE:

Ben's Birthday - 3/9 

Pickup John - 3/9

Brenda's Birthday - 3/10

 

CREW TABLE:

John - Linked to Ben's Birthday, Pickup John, and Brenda's Birthday Records
Rollup field: Arraying unique dates, only return 3/9 & 3/10 as desired. 

However, when trying to count unique dates, it is still counting all the records even if they have the same date. So it returns 3. Help!!

 

1 Reply 1

Hey @Tom_Blanchard

for the counting field please use counter field type and this will return you how many linked records from Task stable are assigned to each crew record.