Countifs
We are trying to build our dashboard and I want a total number of “Deliverables” across five sheets but looking at a column counting where Deliverables is listed and I can't seem to get the formula right and I can't seem to pull in a specific field from a report.
See test formula (across two sheets) and I keep getting Contact Expected.. Is Countfs the right formula?
Answers
-
Hey @RTemples
What column type is the column where you are inserting the formula? Are you trying to put this in a Contact column?
Kelly
-
Hi @RTemples , The #CONTACT EXPECTED error is likely because the column where you have put your formula is a Contact List. Your formula should be expected to return a number (a count) which is not allowed in a Contact List column.
As for your COUNTIFS() formula... it looks fine based on the information you supplied. Just make sure that the word "Deliverables" appears in the cross-sheet columns {TSA Range 2} and {Cyber Security Range 1}. Otherwise you will return zero.
Hope this helps. Good luck and be well!
If my response was helpful or answered your question please be sure to upvote it, mark it asawesome, or mark it as the accepted answer!
-
-
Yeah that is the problem.. I was just trying to put the formula at the bottom of a sheet but the column is a contact list which I guess doesnt allow a count.
-
Yeah that is the problem.. I was just trying to put the formula at the bottom of a sheet but the column is a contact list which I guess doesnt allow a count.
-
Consider using a sheet summary field (Located on right panel alongside sheet). Add a Text/Number field and insert your formula there. You can access Summary fields from dashboards and/or reports
Kelly
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!