COUNTIFS Referencing 3 sheets with two Criteria

MegJF

I'm struggling with this one and could really use some help from the Smartsheet formula geniuses!

On my metrics sheet for a team dashboard, I am trying to pull a count of items that are labeled with the priority level listed at the row and do NOT have a status of "complete".

Below is my attempt and getting an error message of "Invalid Ref"

=COUNTIFS({SHEET1 Range 2}, Title@row, {SHEET1 Range 3}, "Complete" /0) + COUNTIFS({SHEET2 Range 2}, Title@row, {SHEET2 Range 3}, "Complete", /0) + COUNTIFS({SHEET3 Range 2}, Title@row, {SHEET3 Range 3}, "Complete", /0)

Am I close? Please help!

Paul Newcome

Try removing the ", /0" from the end of each of the COUNTIFS.

Paul Newcome

Try removing the ", /0" from the end of each of the COUNTIFS.

MegJF

Paul Newcome, you have once again come to my rescue!

THANK YOU!!!

Paul Newcome

Happy to help. 👍️