Counting Multiple Activities

Kathy Breckenridge
edited 12/09/19 in Smartsheet Basics

I have a sheet that has multiple activities recorded on it.  The attached picture has an Activity Name column and Activity Date column.  We had a Wellness Session on July 19 and a Perioperative session on July 26th.  We will continue having events all year long, so this will not be the only two events on this sheet.  Each row is an individual registering for these events. 

  1. I need a count of how many individuals (rows) attended each activity.   
  2. I need a count of the number of activities held. 

I know Excel Groups items, and you can count that way.  I am not able to figure out how to do this in Smartsheet. 


Activity Name and Activity Date.PNG