Help

Roll Up Min(Value) with a filter

Topic Labels: Formulas
Solved
Jump to Solution
665 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Jason_Jakarta
6 - Interface Innovator
6 - Interface Innovator

Hi,

 

I'm looking for some help with a rollup that is rolling up start dates and returning the earliest date from a table. 

The aggregate function seen on the image is not taking into account the filter I'm trying to apply. I'm trying to return the earliest date on a roll up where the Session Name is not Session Zero.

 

I do I do this in the formula ?

2023-05-01 16_09_29-Logistics Hub_ Cohorts - Airtable.png 

 

1 Solution

Accepted Solutions

Hmm, the values that get used by the formula will be result of the filter criteria you've set if that's what you're asking?

See Solution in Thread

3 Replies 3

Could you provide screenshots of the relevant tables and an example of what you'd like to see?

Hi, 

 

Thanks for your response. I recreated the field and it all worked OK. I'm not sure if I hit a bug but I couldn't replicate it. 

Just to be sure, I assume the aggregate formula is supposed to allow for the filtered criteria when applied? 

 

Cheers 

 

Hmm, the values that get used by the formula will be result of the filter criteria you've set if that's what you're asking?