Why is this #incorrect argument set


=SUMIF([Task Status]:[Task Status], "Completed", [Contact(s)]:[Contact(s)], " ricky torres ")

I'm trying to show the completed tasks in the contacts column, and specifically for the contacts individually.

Ricky T

Gov Contractor for USSF


Best Answer

  • Eric Law
    Eric Law ✭✭✭✭✭✭
    Answer ✓

    @RickyT Ok, so you will need the COUNTIFS formula, not the SUMIF since you have 2 criterion and since there are no numbers to add.

    =COUNTIFS([Task Status]:[Task Status], "Completed", [Contact(s)]:[Contact(s)], " ricky torres ")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!