Unparseable Error

kristi_pei ✭✭✭

02/23/24 in Formulas and Functions

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"))

0 · Share on FacebookShare on Twitter

Sign in

Try Smartsheet

Best Answer

• 

  Carson Penticuff Community Champion

  02/26/24 Answer ✓

  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")

  1 · Share on FacebookShare on Twitter

Answers

• 

  Razetto ✭✭✭✭✭✭

  02/23/24

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

  

  COUNTIFS Function | Smartsheet Learning Center

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

  Counts the number of times all given conditions in their respective ranges are met.

  
  

  1 · Share on FacebookShare on Twitter
• 

  kristi_pei ✭✭✭

  02/26/24

  =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

  0 · Share on FacebookShare on Twitter
• 

  Carson Penticuff Community Champion

  02/26/24 Answer ✓

  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")

  1 · Share on FacebookShare on Twitter
• 

  kristi_pei ✭✭✭

  02/26/24

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

  0 · Share on FacebookShare on Twitter

Sign in

Try Smartsheet

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list