CountIfs between sheets resulting in "0"

rsmith

I have a pretty extensive risk log spreadsheet that I am trying to condense and simplify. Specifically, I want to filter it into a new sheet that will show me the number of risks and issues coming in per week based on the date they were entered into the log. I have been attempting to use the "Countifs" function, however I either get one of many error messages or the results returns a zero. 

For example, I want to find how many issues were assigned on 3/25. When I enter this formula, I end up with zero even though I know there are multiple on that date according to the columns on the sheet I'm referencing. 

=COUNTIFS({Date Assigned}, "03/25/19", {Type}, "Issue")

What am I missing here? The same concept works perfectly in Excel but I need it for Smartsheet so any help would be greatly appreciated! 

Paul Newcome

When referencing a date in a formula, you have to use the DATE function.

 

=DATE(yyyy,mm,dd)

.

Give this a go...

 

=COUNTIFS({Date Assigned}, DATE(2019, 03, 25), {Type}, "Issue")

Nic Larsen

Try this:

=COUNTIFS({Date Assigned}, DATE(2019, 03, 25), {Type}, "Issue")

rsmith

This worked perfectly, thank you very much! 

rsmith

Thank you!!

Paul Newcome

Happy to help!