How Many Items "Closed" Recently


I'm trying to count how many items have been closed in the last 14 days - so "Status" would be "Closed" and the "Date Updated" would be in the last 14 days.

I thought the proper formula would be as I have shown below, but it returns the wrong value.

Any idea where my mistake is?

=COUNTIFS(Status:Status, "Closed", [Date Updated]:[Date Updated], >(TODAY() - 14))

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!