Is there a way to link multiple sheets to a metric for a countif scenario?

CrystalHoran

I am trying to feed the health on multiple sheets into a dashboard using a metric sheet.  I am having trouble adding the secondary location to be included in the formula.  Does anyone know if this is possible?

 

Thank you!

Cathy Fraser

I am look for exactly the some thing. 

Andrée Starå

Hi Crystal,

You'd use a COUNTIFS function to count multiple sheets.

More info: https://help.smartsheet.com/function/countifs

Did you get it working?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

If you are trying to add them all together from multiple sheets, you would use a separate COUNTIFS for each sheet and add them together.

 

=COUNTIFS({Sheet 1}, ...............) + COUNTIFS({Sheet 2}, .............) + COUNTIFS({Sheet 3}, ...............)

Cathy Fraser

Ok, so what would be the formula to look at all sheets and provide a # back for the different states in Australia 

I have added three snap shots that show what I am trying to do.

 

I hope the above makes sense. 

 

 

Paul Newcome

For that many sheets, I would suggest creating a metrics section on each sheet then using cell linking to pull everything to your main metrics sheet. You can then use basic SUM functions to add everything up from there.

 

Otherwise it would look like what I had posted above except much much longer as you would need a COUNTIFS and unique range for every single sheet.

 

You are also more likely to run into the cell linking limits trying to approach it this way as well.