# Display Number only if 2 conditions are met

Options

Good morning,

I am trying to display the lowest bid in a column only if the [BID AMOUNT] cell is not blank AND if the checkbox under [UNVETTED] is NOT checked.

For the first half, I have this:

=IFERROR(SMALL([BID AMOUNT]40:[BID AMOUNT]44, COUNTIF([BID AMOUNT]40:[BID AMOUNT]44, 0) + 1), "")

Which works exactly as I want. But adding the second condition where the box in the [UNVETTED] column is unchecked.

Thanks in advance for your help!

Jeff

## Best Answer

• Employee
Answer ✓
Options

Try adding a COLLECT Function to your formula to identify the second criteria, like so:

=IFERROR(SMALL(COLLECT([BID AMOUNT]40:[BID AMOUNT]44, UNVETTED40:UNVETTED44, 0), COUNTIFS([BID AMOUNT]40:[BID AMOUNT]44, 0, UNVETTED40:UNVETTED44, 0) + 1), "")

Let me know if that works for you!

Cheers,

Genevieve

Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now

## Answers

• Employee
Answer ✓
Options

Try adding a COLLECT Function to your formula to identify the second criteria, like so:

=IFERROR(SMALL(COLLECT([BID AMOUNT]40:[BID AMOUNT]44, UNVETTED40:UNVETTED44, 0), COUNTIFS([BID AMOUNT]40:[BID AMOUNT]44, 0, UNVETTED40:UNVETTED44, 0) + 1), "")

Let me know if that works for you!

Cheers,

Genevieve

Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now

• Options

Hi Genevieve,

Works like a charm!

Thanks!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!