How to Group data in a Report by Year

Min Zhang

Hello, I have exact finish date for each project in the roadmap. But I would like to create a report that can group these projects together by year only, not by specific date, how can I do that?

MCorbin

Add a helper column to your sheet for year. Create a column Formula: =Year([Finish Date]@row)

Add that column to your report. Then you can group by it.