Multiple IF Formulas Based off a Date

DO NOT REPLY SDGE Anthony Bosco

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!

Anthony

Bassam Khalil

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

Bassam Khalil

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

DO NOT REPLY SDGE Anthony Bosco

@Bassam.M Khalil - Thanks so much! This is exactly what I needed :)

Bassam Khalil

@DO NOT REPLY SDGE Anthony Bosco

Am glad it works and i will be happy to help you anytime, Please help the Community by marking it as the accepted answer.