Count rows in sheet for dashboard metrics

I'm a little stuck! I have a sheet that is for Dashboard Metrics and I want to count all the rows in three different sheets to add to my dashboard.

Each sheet contains different contacts so I want to show how many contacts are in the different sheets...what formula can I use on my dashboard metrics sheet to count the numbers? This is what I have so far but it says unparseable. The name of the column I want to count is "Site Name".


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!