Countifs with multiple references

Hello,

I'm in the process of making resource plan worksheet and it needs data from project plan worksheet.


Currently I have tried to pull the data for 'Assigned', 'Open' and 'Delayed' tasks from counting on project plan worksheet and formula used is as follows.


It would be appreciated if you guys can give me a hand to figure this out!

-----

=COUNTIFS({Project Plan - Task}, <>"", {Project Plan - Task Owner / Task Support}, Email@row))

=COUNTIFS({Project Plan - Task}, <>"", {Project Plan - Status}, <>"Completed", {Project Plan - Status} <> "Cancelled", {Project Plan - Task Owner / Task Support}, Email@row)

=COUNTIFS({Project Plan - Task}, <>"", {Project Plan - Status}, "Delayed", {Project Plan - Task Owner / Task Support}, Email@row)


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!