Countifs using cross sheet references



I am trying to get a count of items with these Criteria

Stream = XXX

Window Start <>""

Survey Status = ""

Assignment Status = 

 Vendor Assigned

 Vendor Scheduling

 Late - requested update

This is the current formula I have which is populating a quantity of 0 (Actual count should be 325.

=COUNTIFS({Site Survey Stream}, $STREAM$1, {Window Start}, <>"", {Survey Status}, "", {Assignment Status}, "Vendor Assigned", {Assignment Status}, "Vendor Scheduling", {Assignment Status}, "Late - requested update")

Any help certainly would be very appreciated.

Sharon C.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!