Formula HELP!! count the number of task assigned

Smartsheet Notification

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

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