Using COUNTIFS referencing to another smartsheet

regina.quality

Hello, can I please request for some tips/advise on the Computation Sheet that Im working on.

So this Computation Sheet is just a summary of data that I have extracted from my main sheet (titled MMR Quality Report). So the target is to extract the total number of External and Internal for the month of July. Can someone kindly advise the COUNTIFS formula I can use on my Computation Sheet? Thanks in advance!

Matt Lynn-PCG

@regina.quality

=COUNTIFS({QualityAlert}, NOT(ISBLANK(@cell )),{DateOpened}, IFERROR(MONTH(@cell ), 0) = 7)@cell

Both {} are cross sheet refs that you'll need to make to those columns. This will count any row that is not blank (internal, external or any other value). If you want it to be only those two words, in case someone types something besides that we'd need to modify it some. The easy would be:

=COUNTIFS({QualityAlert}, "Internal",{DateOpened}, IFERROR(MONTH(@cell ), 0) = 7)@cell +COUNTIFS({QualityAlert}, "External",{DateOpened}, IFERROR(MONTH(@cell ), 0) = 7)@cell

Matt Lynn-PCG

@regina.quality

=COUNTIFS({QualityAlert}, NOT(ISBLANK(@cell )),{DateOpened}, IFERROR(MONTH(@cell ), 0) = 7)@cell

Both {} are cross sheet refs that you'll need to make to those columns. This will count any row that is not blank (internal, external or any other value). If you want it to be only those two words, in case someone types something besides that we'd need to modify it some. The easy would be:

=COUNTIFS({QualityAlert}, "Internal",{DateOpened}, IFERROR(MONTH(@cell ), 0) = 7)@cell +COUNTIFS({QualityAlert}, "External",{DateOpened}, IFERROR(MONTH(@cell ), 0) = 7)@cell

regina.quality

@Matt Lynn-PCG

That definitely worked!!

Thank you so much!