Why is this #incorrect argument set

Options

=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

Tags:

Best Answer

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

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!