IF / Then Formula with Dates

I'm trying to create a smartsheet formula for the below information....

If the Form Date Field is 6 weeks(42 days) or less than the event Date then Event Approved = NO. 

If the Form Date Field is 6 weeks(42 days) or more than the event Date then Event Approved = YES. 


Thank you

Answers

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @ShelleyB

    Try something like this:

    =IF([Form Date Field]@row + 42 >= [Event Date]@row, "NO", "YES")


    This adds 42 days to the Form Date Field and checks it against the Event Date cell. If when you add 42 days to the Form Date, it make that date greater than or equal to the Event Date (meaning there are not 6 weeks between the 2 dates), then it returns "NO", otherwise it will return "YES".

    See Use Formulas to Perform Calculations With Dates

    Let me know if this works for you!

    Cheers,

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!