Welcome!

COUNTIF

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!

Find more posts tagged with

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

How to create stack column graph bars
I'm trying to create a graph chart that captures monthly count of records by divisions (Northeast, West and Central) that should be stacked with a legend displaying each by different color like a presented in Excel. When I attempt to duplicate the process in Smartsheet I receive the following results. In Excel, I created…
Linked Dropdown Columns
Good afternoon, I am trying to utilize Linked Dropdown Columns for a manual process we have. We have many sheets that use a "Client Name" column with a dropdown list. Whenever a new client comes on or exits, we have to manually update every sheet that has a Client Name column and update the dropdown list. We do not have…
How do the automated notification attachment triggers work?
This should be straightforward information but I can't find it anywhere. How do the Automation triggers work for attachments? I assumed: An attachment is Added = New attachment An attachment is Changed = New version of existing attachment. But I just had an 'Added' attachment notification trigger when I uploaded a new…