Formula with two column dates and show the higher


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


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!