#Incorrect Argument Set with =COUNTIFS

DKazatsky ✭✭✭
edited 01/11/23 in Formulas and Functions

Hi all,

This is baffling me. I have a very simple formula...

=COUNTIFS({Epic Name}, [Primary Column]@row, {Current Sprint}, 1).

I am using this for a metrics sheet to be used for dashboard reporting. This is working as expected in it's own sheet but when I use the exact same formula in a bigger/consolidated metric sheet, it returns "#Incorrect Argument Set".

Does anyone know why it works on one sheet but not another?




Best Answer

  • DKazatsky
    DKazatsky ✭✭✭
    Answer ✓


    It looks like the reference was the issue when I cut/paste the formula. Even thought the same reference was being used in the current sheet, when I reinitialized the reference, everything worked as expcted.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!