Multiple IF Formulas Based off a Date


Hello Everyone,

I'm trying to create a formula with multiple IF statements. So far, I have the following created: =IF([OH Date Qualified]@row < TODAY(-1080), "Designer 2"), IF([OH Date Qualified]@row < TODAY(-1800), "Designer 3"), IF([OH Date Qualified]@row < TODAY(-3600), "Designer 4")

However, the above formula only works with one IF statement. I'm trying to have a designer level populate based off the following criteria:

Designer 1 - 0+ years of experience after qualified date

Designer 2 - 3+ years of experience after qualified date

Designer 3 - 5+ years of experience after qualified date

Designer 4 - 10+ years of experience after qualified date

Your help would be greatly appreciated.

Thank you!



Best Answer

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Answer ✓

    Hi @DO NOT REPLY SDGE Anthony Bosco

    Hope you are fine, please try the following formula and convert it to the column format formula:

    =IF([OH Date Qualified]@row < TODAY(-3600), "Designer 4", IF([OH Date Qualified]@row < TODAY(-1800), "Designer 3", IF([OH Date Qualified]@row < TODAY(-1080), "Designer 2", IF([OH Date Qualified]@row < TODAY(-365), "Designer 1"))))

    the following screenshot shows the result

    PMP Certified

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!