SUM duration / COUNT task if assigned to is empty

Options

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!