COUNTIF

@Help

Hello,

Is there a formula  where I can filter two check box columns. First check column is "Project Completed" and second column is "Urgent Request". So I wanted to know how many projects I have as:

"Urgent Request" Check

"Project Completed" Uncheck

I tired

  =COUNTIFS([Urgent Request]:[Urgent Request], 1, AND([Project Completed]:[Project Completed], 0))

but I get #INVALID DATA TYPE

 

Thanks!

Mike Wilday

Check the column type of the column you are trying to use the formula in. It should be set to Text/Number. Here is some vague and generally unhelpful information on that error! 

https://help.smartsheet.com/articles/2476176-formula-error-messages#invaliddatatype

@Help

It is a Text/Number type of column

Paul Newcome

It is your AND statement. COUNTIFS basically has the AND already built in. Give this a try.

 

=COUNTIFS([Urgent Request]:[Urgent Request], 1, [Project Completed]:[Project Completed], 0)

@Help

It worked,

Thanks!

Mike Wilday

@Paul Good catch. Thanks! 

Paul Newcome

Happy to help! 

Paul Newcome

 

By the way... I got a kick out of your comment about the error description.

 

"Here is some vague and generally unhelpful information on that error! "

 

Hahahaha

Mike Wilday