Welcome!

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.

Find more posts tagged with

Comments

Ella

Try by removing the [ASSIGNEE: ASSIGNEE] from the formula.

Paul Newcome

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")

Sign in to join the conversation!

Quick Links

Trending discussions

Is it a bug? "Removing user Access" by clicking X - works sometime and then it does not.
Hi everyone, I'm the owner of worksheet/workspace and am currently unable to reliably remove user access through the "Manage Access" panel. This issue just started occurring recently. The Problem: When I click the "X" next to a user's name to remove them, it works for the first user. For any subsequent user, the "X"…
Can one cell change cause workflows in multiple grids?
I'm trying to move data from two grids (Grid #1 and Grid #2) using workflows (When rows are changed) to archive grids when a cell is ONLY updated on Grid #1. Here is my setup and what the issue I'm having… Grid #1 has the column that is being updated. Workflow setup on Grid #1 to move the row when the cell is changed to a…
Slow loading
Helloe Everyone! I’m trying to reference another sheet in Smartsheet, but I’ve noticed that sometimes it loads quickly, while other times it takes a very long time to display the list. Does anyone know why this happens? Is there a way to reduce how often this issue occurs? Today, I can’t get anything to load at all. 😑