Cell-linking - counting values from a sheet into the cell of another sheet


Hi everyone,

I'm trying to create an event summary sheet that captures data from individual event sheets to provide a live overview on where we're at with completion, health, risks, status, etc.

And so I have a cell "Health" in my specific event sheet that has a number of dots (red, green, gray) depending on with the task is completed, in progress, or at risk.

In my event summary sheet, I'd like to have a cell that counts all the red dots from the event sheet but I'm struggling with COUNTIF and the range, getting messages such as cells need to be next to each other (which they are). Does someone have a possible solution please?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!