Using Or to Reference to Different Columns

Anthony Barthelemy

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

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)

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)

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