Date Calculations and auto-update

Would like to have a formula where if the 'Extension Closure Date' is = or after the 'Target Closure Date', then the 'Target Closure Date' will automatically update to the 'Extension Closure Date', if not, then the 'Target Closure Date' will stay the same. Thank you.

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Yes. That would be exactly what I mean by the first bit regarding a separate column.

    The easiest formula to evaluate both and pull the appropriate would be a basic MAX function.

    =MAX([Extension Closure Date]@row, [Target Closure Date]@row)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!