I would like to create an if/ then statement =IF([Launch Date]5 > [Start Date]5) = 1

Essentially asking it to compare 2 dates. If the first is larger, then give a 1. If the second is larger give 0.

Best Answer


  • Thanks Frank this helps.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!