Summary by Client


I created a ticketing process and the result is a list of tickets in a sheet. I want to be able to report on tickets by client. I am trying to avoid maintaining a list of clients for the report. In excel I would use a pivot table, I am trying to avoid needing that addon. Is there a way to take a list of data and summarize it by a column, when I don't have a pre-defined list of what is in that column?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!