Sign in to join the conversation:
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!
I am look for exactly the some thing.
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
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}, ...............)
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.
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.
Hi there, I've created a sheet to where my team is tracking information received. In one column, we are logging the date and time information came in (ie: November 21, 2025 8:30 AM). I would like to add a checkbox column, with a formula specifying that the box be checked if the logged time is AFTER 8:30 AM, and left…
I have a list of properties that I'm keeping track of. I have each building divided into suites (children) and each suite has a cell with its square footage. The total square footage rolls up to the building name. I also have a drop down column that shows if the suite is occupied or vacant. I need a to calculate the…
Hi! I'm fairly new to SmartSheets but have been trying a number of things that havent yet worked. I want to be able to show for each parent row, the number of child rows completed as a %. So for the parent row Process Overview there are 7 tasks and 6 tasks are complete so I want it to show as 90%. Can anyone help me?
