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 do i get a rollup with formula Min()to stop returning zero when rolling up empty cells?

Topic Labels: Formulas
Jump to Solution
478 2
Showing results for 
Search instead for 
Did you mean: 

In [Workers] I have a rollup field called {Lowest_rating} which uses the Min() formula to return the lowest number a worker has in [Worker Interactions]. FWIW, the field in [Worker Interactions] that is being rolled-up is a number field.

Where the worker has no rating yet, the rollup returns a “0”. I find this to be visually confusing. Is there anyway in the rollup to return the cell empty rather than a zero? Photos below.




1 Solution

Accepted Solutions
2 Replies 2

Try: IF(values, MIN(values))

Awesome. Thank you, Kamille!