Can you combine if and or formulas

Here is the formula that I currently have and works great currently:

=IF(COUNTIFS({UCA App E#}, [E #]@row, {EPU approved}, true) > 0, true, false)

First is the match the text in "UCA app e#" and "E #", but also needs "EPU approved" which is a checkbox, to be 'checked'. I need to add a second field that is a check box to also bring back true if 'checked'.

So the logic would be, IF a match to the text in E# field is yes, AND either "EPU approved" OR "logged for future" is checked, then bring back the value of true (also a checkbox).

Find more posts tagged with

Accepted answers

Genevieve P.

Hi @Nate Ensor

Looks like you're missing a > sign before the second 0, and the "true" / "false" statement at the end.

Try this:

=IF(OR(COUNTIFS({UCA App E#}, [Entegra E #]@row, {EPU approved}, true) > 0, COUNTIFS({UCA App E#}, [Entegra E #]@row, {approved for future}, true) >0), true, false)

Cheers,

Genevieve

All comments

Darren Mullen

@Nate Ensor You could wrap a couple CountIFs in an or() .

OR(COUNTIFS({UCA App E#}, [E #]@row, {EPU approved}, true) > 0 , COUNTIFS({UCA App E#}, [E #]@row, {logged for future}, true) >0)

Then put that in your IF statement logic expression

Nate@E

ok I gotcha. Makes sense, countifs match listed twice combined with the true statement for both other columns.

I still can't quite put it together though, I'm missing something or it's getting late lol...but I'm getting the unparseable error. Not as simple as just putting "IF" at the beginning?

=IF(OR(COUNTIFS({UCA App E#}, [Entegra E #]@row, {EPU approved}, true) > 0, COUNTIFS({UCA App E#}, [Entegra E #]@row, {approved for future}, true) 0))

Genevieve P.

Hi @Nate Ensor

Looks like you're missing a > sign before the second 0, and the "true" / "false" statement at the end.

Try this:

=IF(OR(COUNTIFS({UCA App E#}, [Entegra E #]@row, {EPU approved}, true) > 0, COUNTIFS({UCA App E#}, [Entegra E #]@row, {approved for future}, true) >0), true, false)

Cheers,

Genevieve

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.