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.
Formula was flowing correctly, but some change seems to have partially broken the pull but I can't figure out what/how. "Project" column dropdown is linked to a Master sheet. Budget Owner column contains the below formula which should look for the cell value in the Project/Cost Center/IO column within the P+CC+IO column of…
I have a sheet that I was able to calculate minutes and seconds using this formula. =VALUE(LEFT(Time@row, FIND(":", Time@row) - 1)) + VALUE(RIGHT(Time@row, 2)) / 60 Now I’m working on a form that needs to include milliseconds. I tried using the above formula and adding milliseconds but my formula returns an #INVALID VALUE…
I was able to create a Smartsheet column with time included with the date (Thank you @Paul Newcome & @Akblevins ). I want to add another column that just shows the time - I used the AI Smartsheet feature to create a formula but receive an error message. Any ideas on how to correct? TIA!
