COUNTIF

kmccready07

Hello I am trying to create a count if function-

My current sheet, Assigned Counter needs to return a tally with each "article" assigned to a trainer.

So under the articles assigned i'm trying to use a countif function to return the number of articles assigned to a specific trainer.

I am trying to use

=COUNTIF(Request Tracker Working Sheet Range 2},Trainer@row ** the Trainer@Row information is on my current sheet Assigned Counter. and my Range- Request Tracker Working Sheet Range 2- is referencing a different sheet- I keep getting an unparseable error.

How can i get it to return the number of articles assigned to a specific Trainer listed on my current sheet i am working?

David Ruff

Hi kmccready07,

Here is a help article on using the COUNTIF function in Smartsheet: https://help.smartsheet.com/function/countif

It looks like your reference to the other sheet is just missing the "{" in front. You can try this: =COUNTIF({Request Tracker Working Sheet Range 2}, Trainer@row).

Hope this helps!