Help

How do i get a rollup with formula Min()to stop returning zero when rolling up empty cells?

Topic Labels: Formulas
Solved
Jump to Solution
1039 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Eli_Kent
7 - App Architect
7 - App Architect

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.

image

image

thanks!

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus

Try: IF(values, MIN(values))

See Solution in Thread

2 Replies 2
Kamille_Parks
16 - Uranus
16 - Uranus

Try: IF(values, MIN(values))

Awesome. Thank you, Kamille!