How to display smaller data with an if

wagner silva

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"

Paul Newcome

Try something along the lines of...

=MIN(COLLECT([Data de Validade]:[Data de Validade], [Responsavel (area)]:[Responsavel (area)], "Comercial"))

Depending on your region, you may need to swap commas for semicolons.

=MIN(COLLECT([Data de Validade]:[Data de Validade]; [Responsavel (area)]:[Responsavel (area)]; "Comercial"))