Minimum of a certain range


I'm trying to use a formula to find the oldest date for a certain range of rows. Is there a similar MIN function as there is to SUMIF or COUNTIF? Or some similar work around?

This is my attempt, but it does not work:

=MIN(IF({PM Sheet Region} = "TQM", {Column of Dates Here}))


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!