SUM duration / COUNT task if assigned to is empty

Roxana

Hi,

I want to produce some metrics based on my project plan but I am getting errors / incorrect values when:

1) Count task that where the "Assigned To" is empty

2) SUM the duration of those tasks, where the "Assigned To" is empty

I've been trying something like this, but doesn't seem to work:

=COUNTIF({Assigned To:Assigned To}, @cell = "")

Paul Newcome

Make sure you are creating your cross sheet references properly:

https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets#toc-reference-data-from-another-sheet