Using COUNTIFS referencing to another smartsheet

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!
Best Answer
-
=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
Answers
-
=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
-
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives