In addition to being able to count and sum a column in a report, I'd like Smartsheet to be able to count UNIQUE values within a group.
For example, I have a report shows me all tasks from multiple projects and groups by project manager. If I try to count the Project column to see how many projects each Project Manager has work on, Smartsheet returns the number of Tasks, not the number of Projects. If I could count unique values, I'd be able to get the metric I want and then create the figure I want.
Right now, I have to do a work-around using pivot tables to consolidate the data first, which is not ideal long-term.