How to ignore (0.00) when using SMALL Formula

I have 3 columns and each row I would like to return the smallest number. If one of the three columns contains a zero then I would like to return the NEXT smallest - essentially ignore the zero (0.00). How do I accomplish this?


Best Answer

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓


    Min Column2 formula:

    =MIN(COLLECT([Column2]:[Column2], [Column2]:[Column2], >0))

    Min Column3 formula:

    =MIN(COLLECT([Column3]:[Column3], [Column3]:[Column3], >0))

    Min Column4 formula:

    =MIN(COLLECT([Column4]:[Column4], [Column4]:[Column4], >0))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!