Using Or to Reference to Different Columns

Good Evening:

Not sure how to add an Or to my Formula that Reference 2 Different Columns. I would like to add to my Count if the Id Column has Analysis or If the Issue Type Column has Task

Current Formula which Returning an Error:

=COUNTIFS({Sprint}, "ACAMS 2.0 SF - Sprint 9", {Bus Status}, "Done", {ID}, "Analysis", OR( {Issue Type}, "Task"), {Rollover}, 0)

Thanks

Find more posts tagged with

Accepted answers

Mark Cronk

Hi @Ray B ,

Using OR here is a bit tricky. Instead try this:

=COUNTIFS({Sprint}, "ACAMS 2.0 SF - Sprint 9", {Bus Status}, "Done", {ID}, "Analysis", {Rollover}, 0) + COUNTIFS({Sprint}, "ACAMS 2.0 SF - Sprint 9", {Bus Status}, "Done", [Issue Type}, "Task", {Rollover}, 0)

Work?

Mark

Anthony Barthelemy

No Received an Error, but I found what was incorrect. The wrong type of bracket was used Issue Type at the beginning. However, I did not think of using + to get me the Results I wanted; therefore, thank you.

Updated Formula:

=COUNTIFS({Sprint}, "ACAMS 2.0 SF - Sprint 9", {Bus Status}, "Done", {ID}, "Analysis", {Rollover}, 0) + COUNTIFS({Sprint}, "ACAMS 2.0 SF - Sprint 9", {Bus Status}, "Done", {Issue Type}, "Task", {Rollover}, 0)

All comments

Mark Cronk

Hi @Ray B ,

Using OR here is a bit tricky. Instead try this:

Work?

Mark

Anthony Barthelemy

Updated Formula:

Mark Cronk

Perfect. Happy to help. If the issue is resolved please accept my answer to close the discussion. Thank you for using the Community.

Be well,

Mark

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.