COUNTIFS formula issues
Can someone tell me what's the issue with my formula, I get "#unparaseable" for result.
And maybe add a date range per month.
Thank you!!!
Best Answer

If RR is the field value you are looking for, you need to put it in quotes. Also, do you have other criteria follow that? If not, remove the , after <=1. Last  if I am having a problem with a multipart formula, I will usually test what is making it fail by doing it in pieces. For example  =COUNTIF({CCS Scheduling Range 1 SALES},"RR")
=COUNTIFS({CCS Scheduling Range 1 SALES},"RR", {CCS Scheduling Days over}, <=1,)
I am fairly new to Smartsheets so hopefully this makes sense.
Answers

If you are using Countifs on a date column, make sure that the column property is set to Date. Do you have an example of the formula?

=COUNTIFS({CCS Scheduling Range 1 SALES}, RR, {CCS Scheduling Days over}, <=1,)
 *" CCS Scheduling Range 1 SALES"  referencing another sheet
Here is my formula that gives me #unparaseable as result.
I would like to add the date range per month to this too.

=COUNTIFS({CCS Scheduling Range 1 SALES}, RR, {CCS Scheduling Days over}, <=1,)
 *" CCS Scheduling Range 1 SALES"  referencing another sheet
Here is my formula that gives me #unparaseable as result.
I would like to add the date range per month to this too.

If RR is the field value you are looking for, you need to put it in quotes. Also, do you have other criteria follow that? If not, remove the , after <=1. Last  if I am having a problem with a multipart formula, I will usually test what is making it fail by doing it in pieces. For example  =COUNTIF({CCS Scheduling Range 1 SALES},"RR")
=COUNTIFS({CCS Scheduling Range 1 SALES},"RR", {CCS Scheduling Days over}, <=1,)
I am fairly new to Smartsheets so hopefully this makes sense.
Help Article Resources
Categories
Check out the Formula Handbook template!