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

Formula to Check Restricted items in a Multi List Drop Down
I have a field "Failure Summary" in a sheet that has a drop down list that allows multiple selections. I want to write a formula that will check mark those specific items in the drop down list, if a corresponding column@row has "NO" as the value in that field. Is it possible to write a formula to do this?
#UNPARSABLE / #INCORRECT ARGUMENT
Having trouble trying to make this formula work. Perhaps it needs re writing using different syntax. I understand that perhaps i am using too many arguments for the IF command. I am looking to achieve the below. If Column1 is not blank and Column2 is not blank, return "Answer 1". If Column1 is not blank and Column2 is…
I want to create an equation based on complex matrix
I am trying to change the status of a column, base on the top five impact levels ( Not Significant, Minor, Moderate, Major and severe) based on the conditions below. Would I have to nest in 25 equations, or does smartsheets have a simpler way of reaching this solution?