Nested IF, AND Function


Good morning

I am trying to write a formula that incorporates the following criteria (screenshot below):

IF "Date Received" is <= "Closing Date" AND "Received" is checked, then "Application Received"

IF "Date Received" is > "Closing Date" AND "Received" is checked, then " Late Application"

IF "Received" is not checked, then "No Application Received"

I have tried so many variations and being a novice to smartsheet, I can't seem to get it right. I will have the "Closing Date" hidden once completed.

Is anyone able to assist?

Thanks in advance!

Best Answers


  • Natasha D
    Natasha D ✭✭✭

    Thanks Paul and Mike! Both of those work and make complete sense.

    I appreciate the help.

    Paul, thank you for the extra tips on formulas. I realised number 1 yesterday after watching brackets disappear in other formulas as I was typing them. Will certainly think of this when creating column headings in the future.

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    @Paul Newcome

    Which I am really good at forgetting..

    Aren't we all???? 😂😂😂

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!