Formula HELP!! count the number of task assigned

Hi I am trying to count the number of task assigned to specific person in contact cell

=IF(ISBLANK({2021 MR & MI Online Update Sheet v1 Range 2}), COUNTIF(({2021 MR & MI Online Update Sheet v1 Range 4}), FIND([Column2]@row, @cell) > 0))

the error is incorrect argument

Answers

  • Heather Duff
    Heather Duff ✭✭✭✭✭✭

    Hi! It may be helpful to provide screenshots (with sensitive data blocked) so that we can see what your ranges refer to, etc.

    Here's how I would set it up on my own sheet, though:

    =COUNTIF({Contact},[Name]@row)

    Where {contact} is the named range for the contact column in the source sheet, and [name] is the contact column in the summary sheet.


    Hope this helps!

    Best,

    Heather

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!