COUNTIFS from Another Sheet is not working
Hi, I am trying to use countifs by referencing another sheet. Here's what/how I am trying to create a report from another smartsheet:
I am trying to count the different type of Tickets for each of my developers. For example, for David I want to count how many Problem ticket has been assigned to him and how many request ticket has been assigned to him. I am referencing another sheet but it's showing "UNPARSEABLE"
=COUNTIFS({31Web Team Task Management Range 1}, [ASSIGNEE: ASSIGNEE] "DAVID NICKS", [TICKET Type]:[TICKET Type], "Problem")
Please Help. Thanks.
Comments
-
Try by removing the [ASSIGNEE: ASSIGNEE] from the formula.
-
HERE is some info on referencing data in another sheet.
When you reference another sheet, you select the column (or other range) that you want to reference, and the name generated (or whatever you change the range name to) will always refer to that specific range.
When you are creating the cross sheet references, first select the Assignee column in the other sheet, enter the criteria for that column's range, then use the appropriate steps to create a second cross sheet reference and select the Ticket Type column. Then you can add the Ticket Type criteria, and the formula should be working.
It would end up looking something like this...
=COUNTIFS({31Web Team Task Management Assignee Column}, "DAVID NICKS", {31Web Team Task Management Ticket Type Column}, "Problem")
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.2K Get Help
- 361 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives