# of occurrences formula

Question

I want to show how many times in the past six months that a supplier has had a complaint issued against them.  This is the formula I am using but it returns all zero's.

=IF(Supplier@row = "", "", COUNTIFS(Supplier:Supplier, Supplier@row, [Date Submitted (Created Date)]:[Date Submitted (Created Date)], ">=" + TODAY(-180)))

This is a snip it of my column names. Any ideas?  thanks in advance!  And if there is a simpler formula, please suggest it! This one came from copilot.  I don't really have to have the first if statement because there is always going to be a supplier.

Paul Newcome · Accepted Answer

That looks to have a little Excel mixed in. Give this a try:

=IF(Supplier@row = "", "", COUNTIFS(Supplier:Supplier, Supplier@row, [Date Submitted (Created Date)]:[Date Submitted (Created Date)], @cell >= TODAY(-180)))

Paul Newcome · Accepted Answer

It was that little bit before the TODAY function.