Formula with two column dates and show the higher

Options

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

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!