COUNTIFS with reference to another sheet more than one criterion

edited 12/09/19 in Formulas and Functions

I'm very confused about this function. It has an #UNPARASABLE error.

=countifs({Jade2_BCM Dashboard 2019 Range 1},"Complete",[{Jade2_BCM Dashboard 2019 Range 2},"Business Resilience",{Jade2_BCM Dashboard 2019 Range 3},"1st Quarter")

I am trying to reference three columns from another sheet, Jade2_BCM Dashboard, to see how many rows are marketed as complete, are from the 1st Quarter, and are under Business Resilience. Does anyone know why I am getting this error?



  • Frank Falco
    Frank Falco ✭✭✭✭✭✭

    Try removing the [ in "Complete",[{Jade2_BCM Dashboard 2019 Range 2}, the [ ] are used when referencing a column name in the same sheet that has a space in it, it is not required when referencing columns in another sheet.

    ✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

  • Thank you! That worked. I no longer have an error.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!