Formula Help with CountIf from another sheet
I'm trying to get the total count from a column in another sheet. The column is a drop down list and I'd like to get the count of a particular selection. I keep getting #unparseable no matter what I try. Here is my current formula.
=COUNTIF({Source Sheet Column}:{Source Sheet Column},CONTAINS("Discovery",{Source Sheet column}@row))
My hope is that I will get the total count of rows that contain 'Discovery'. in the identified column from the source sheet.
Best Answer

So I figured out an interim solution here using the formula below. Essentiallly I have a metric sheet where I keep all my formulas. The drawback to the solution, if I have to maintain the data in the metric sheet. Ideally, I can pull the information from the source sheet and use some formula language to get the count.
=COUNTIF({Source sheet column}, Summarysheetcellnameandnumber)
FWIW, I figured this out from the Templet Set  Facilities Management. Below is an example of the forumla from that template set.
=COUNTIF({Sheet  Work Order Requests  Range_WO Type}, Primary13)
Answers

So I figured out an interim solution here using the formula below. Essentiallly I have a metric sheet where I keep all my formulas. The drawback to the solution, if I have to maintain the data in the metric sheet. Ideally, I can pull the information from the source sheet and use some formula language to get the count.
=COUNTIF({Source sheet column}, Summarysheetcellnameandnumber)
FWIW, I figured this out from the Templet Set  Facilities Management. Below is an example of the forumla from that template set.
=COUNTIF({Sheet  Work Order Requests  Range_WO Type}, Primary13)
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 410 Global Discussions
 219 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!