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 currently have 14 sheets with the following columns: Batch # and Reviewer I use an Index Distinct formula to acquire the unique batch numbers from all 14 sheets and put them into 14 columns on the 'metrics' sheet. I then use another index distinct to get a list of all the unique batch numbers into one 'Unique Batch…
From my research, I understand there isn't a way to keep formulas when exporting from Smartsheet into an Excel document. I have a total of 50 columns with formulas and would think there was a quicker way to grab the formulas. So far, I've appended a "!" which turns the formula into text which does export. However, I'm not…
Hello, I am looking for formula help where I want to return the earliest date in a range for different workstreams groups on a project. The source sheet is formatted as a date field, and the formula used below is returning a 0 no matter what I do. Any suggestions? =MIN(COLLECT({Project Plan - start date}, {Project Plan…
