Help with formula
I am creating a Metric sheet to count if three column criteria are met on the source sheet. The sheet references I have made are all caps.
I have tried variations of the below:
=COUNTIFS({TYPE:TYPE}, "HM", {ROLE:ROLE}, "Physician",{REGION:REGION}, "South")
Does anyone know how this formula should be written?
Answers
-
Hi @Alane
In your metric sheet, you will need to create references to the three columns. When you type in =COUNTIFS, you will see a link below to create a reference from another sheet. Click on it and create the reference with any preferred reference name for each reference. Since you will be referencing the entire column, if you use the same names as the columns in the source, your formula will look something like this =COUNTIFS({Type}, "HM", {Role}, "Physician", {Region}, "South"). References are not case sensitive.
Thanks,
Aravind GP| Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!