SUM duration / COUNT task if assigned to is empty



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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!