Formula with two column dates and show the higher

Raul Cabrera

Hi good day. I have a sheet with 2 column dates. "Mitigations date 1" and "Mitigation date 2", i need a formula in a third column that shows me the higher in these 2 columns. If Mit 1 is higher then show that if Mit 2 is higher then show Mit 2. That column will be my column to show in an dashboard items with past due dates.

Thanks all

hollyconradsmith

Hi @Raul Cabrera ,

Try =MAX([Mitigations date 1]@row:[Mitigations date 2]@row)

https://help.smartsheet.com/function/max

hollyconradsmith

Hi @Raul Cabrera ,

Try =MAX([Mitigations date 1]@row:[Mitigations date 2]@row)

https://help.smartsheet.com/function/max

Raul Cabrera

Works perfect. Thanks Holly