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

Find more posts tagged with

Formulas

Accepted answers

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

All comments

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:

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.