Help with COUNTIFS

Desmond Smith

Desmond Smith ✭✭

03/09/22 in Formulas and Functions

Trying to count closed cases in a date range, formula won't work:

=COUNTIFS({AAA Range 4}, <= DATE(2021, 8, 01), {AAA Range 4}, >= DATE(2021, 10, 30), {AAA Range 2}, "resolved))

Is there something wrong with my formula?

Tags:

Formulas

0 ·

Answers

Jeff Reisman ✭✭✭✭✭✭

03/09/22

@Desmond Smith
Looks like you're missing close quotes for "resolved" in your formula:
"resolved))
You have an extra end parentheses there when it should be "resolved")

Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Help to identify all x.x.1 cells
I have a WBS column that I'm joining with a resource row count to provide a distinction for tasks not just by hierarchy but by resource. I need to be able to exclude the very first task per assignee in the first hierarchy only. How do I identify only the x.x.1 tasks in a column? I need to create a formula for all RBS =…
Flagging dates overlap
Hi Smartsheet stars, I try to flag jobs overlaps using COUNTIFS function as per screenshots below (tried two different options), however, it doesn't show me 3 overlaps I currently have in my Smart sheet (I created a new A and AAA projects with conflicting dates but it has not been flagged for some reason). Could you please…
Trying to get an accurate count of checked boxes in a report
hi there, I am trying to get my report to only count boxes checked in each row. instead, it is counting the checked and unchecked boxes, which doesn't translate into my dashboard report. Is there a way to make sure it only counts check boxes for each summary?