Find oldest value where certain conditions exist



I'd love some advice on building a formula. My data includes a column for DATE, a column for STATUS (either "Current" or "Archived"), and a column for TYPE ("Red", "Yellow", or "Blue").

I need a formula that returns the oldest date where both STATUS and TYPE meet the selected criteria, i.e. What is the MIN date for all records that are both "Current" and "Red"?


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!