Multiple IF Formulas Based off a Date

Options

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

Tags:

• ✭✭✭✭✭✭
Options

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.khalil2009@gmail.com

• ✭✭✭✭✭✭
Options

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.khalil2009@gmail.com

• Options

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

• ✭✭✭✭✭✭
Options