IF( AND Formula with a Flag

I have a formula that I'm trying to implement, I'm saying if the year closed is prior or equal to 2021 and the finance completion % is lower and equal to 89 percent. Then flag the project. Here is my formula below

=IF(AND([Corporate Finance Completion %]@row = "", [Year Closed]@row = ""), 0, IF(AND([Corporate Finance Completion %]@row <= 0.89, [Year Closed]@row <= 2021), 1, 0))

Find more posts tagged with

Accepted answers

Paul Newcome

Try this:

=IF([Year Closed]@row <> "", IF(AND([Corporate Finance Completion %]@row <= 0.89, [Year Closed]@row <= 2021), 1))

All comments

Paul Newcome

It looks like it should be working. Are you able to provide a screenshot of the data where it isn't working for you?

Andrée Starå

Hi @Tawakoni Hill

I hope you're well and safe!

What happens? Do you get an error message?

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Tawakoni Hill

I'm not getting an error but the flag is not turning red in all situations. Also its turning red when the year is blank and Im not wanting it to do that.

Paul Newcome

Try this:

=IF([Year Closed]@row <> "", IF(AND([Corporate Finance Completion %]@row <= 0.89, [Year Closed]@row <= 2021), 1))

Tawakoni Hill

Thanks that worked out perfectly!!!

Paul Newcome

Happy to help. 👍️

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.