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.
I have two formulas which work well independently, but when I combine them they don't. formula 1: =IF(YEAR([Joined date]@row ) = 2025, JOIN(COLLECT({Membership Survey 2025 - Experience}, {Membership Prioritisation Survey 2025 - Org}, [Organisation name]@row ))) formula 2: =IF(YEAR([Joined date]@row ) < 2025,…
Hello, I use Smartsheets in a Higher Education setting. I have one sheet (Sheet A) for a list of students this sheet contains their student id numbers, email addresses, as well as other helpful information. I built a If Yes/If No check column on this sheet as well. My next sheet (sheet B) is a form that is asking is the…
I need to extract information from 2 different sheets based on the name of the member organisation and the join year (i.e. DD/MM/YYYY). The 2 sheets have the same column titles, but one is for 2024 and another one for 2025. Where organisation joined earlier than 2025, then it needs to fetch the data from the 2024 sheet,…
