Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How To Rollup MIN(values) of "1" or Greater, Excluding "0"

Topic Labels: Formulas
622 0
Showing results for 
Search instead for 
Did you mean: 

I’m trying to roll up the smallest value from Table A into Table B that’s at least “1” or greater with MIN(values) rollup formula. The problem right now is some is table A has values of “0”, and I don’t want to return that number. Example below:

record #: 4
record #: 2
record #: 15
record #: 21
record #: 0

My formula returns the smallest number in table A, which technically is “0”, but I don’t want that number, and I’m trying to figure out a formula to exclude any value of 0 or less.

0 Replies 0