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!
Anthony
Best 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
bassam.khalil2009@gmail.com
βοΈ 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"
Answers
-
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.khalil2009@gmail.com
βοΈ 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"
-
@Bassam.M Khalil - Thanks so much! This is exactly what I needed :)
-
@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.
bassam.khalil2009@gmail.com
βοΈ 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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!