Group by and/or Count by in Smartsheets

Elizabeth Smeller
Elizabeth Smeller ✭✭✭
edited 12/01/20 in Formulas and Functions


Does Smartsheets have the ability to 'group by' and/or 'count by' similar to the excel pivot table? I have a master list of projects for my entire organization and I would like to be able to do the following:

  1. Filter by Status AND
  2. Group by PM Name (Assigned To) AND
  3. Count of Projects/Clients by PM Name

See example of excel report below - can Smartsheets do something similar or no?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!