Unparseable Error

kristi_pei

I am can't figure out why I am getting the error, if anyone can help

=COUNTIFS([Start Date]:[Start Date],"<="TODAY(),[Module]:[Module],"Retail"))

Carson Penticuff

The range and conditions need to be separated by commas instead of directly comparing them.

=COUNTIFS([Start Date]:[Start Date], @cell <= TODAY(), [Module]:[Module], "Retail")

Razetto

@kristi_pei Hi, remove the quotation marks for the date <=TODAY() and remove the extra bracket

https://help.smartsheet.com/function/countifs

kristi_pei

=COUNTIFS([Start Date]:[Start Date] <= TODAY(), [Module]:[Module] = "Retail")

Hi! Thank you for your help. Now I am getting an #invalid operation error. I guess that it is progress

Carson Penticuff

The range and conditions need to be separated by commas instead of directly comparing them.

=COUNTIFS([Start Date]:[Start Date], @cell <= TODAY(), [Module]:[Module], "Retail")

kristi_pei

YES!!! That worked. Thank you both!! I am so excited that this was resolved!