Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Formula HelpFinding the minimum value greater than zero
Options
Comments

I don't know of a way to do this in a single formula but here's one way that I can see to do it. First create a new column and in each row of the area that you want to find the >0 minimum for, enter the formula: =IF(Ref>0,Ref,"") where Ref is the entry in the same row that participates in the search for the nonzero minimum. If the row in interest is zero or negative the formula rill return a blank. Then, at the bottom of the new column enter =MIN(Ref1:Ref2). The minimum nonzero value will be found.
You might also be able to do this with a report since you can control what the report looks for in the row in question by looking for numbers >0 in the rows and sorting by values.
This discussion has been closed.