Countif formula?


Trying to create this sheet for a medical office that gets referrals from multiple sources. This works on excel but having a hard time getting the formulas to work on smartsheet.

I'm assuming that I use the countif formula but not sure it there is a better way. I want to count the number of referrals from each source for each month and grand total and show it on the dashboard. Sorry I just started with smartsheet and trying to figure it out.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!