How to display smaller data with an if

Options

I have 2 columns, "@data" and "@responsible", I need to display the smallest date if the responsible is "x".

Example:

Example:

I need to display the lowest date when the colum "@Responsável (area)" is "commercial"

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!