How to group SharePoint list data by year using a calculated column

Published: 01 May 2022
on channel: Nate Chamberlain
8,153
38

You can automatically show just the year from an existing date column by creating a calculated column in a SharePoint list. We can then use that calculated column (a Year column) to create a grouped view that easily shows us our data in collapsible sections by year.

Check out how to do this in a way that includes MONTH too at    • How to extract month and year from Sh...  .

Learn other ways to extract date components in other formats here: https://sharepointlibrarian.com/2018/...

Learn more about filtering and grouping here: https://sharepointlibrarian.com/2018/...

Subscribe to this channel: https://bit.ly/3fWYhZQ
Donate to help support: https://bit.ly/3AE3M99
LinkedIn:   / nchambe  
Twitter:   / chambernate  
Website: https://NateChamberlain.com


Watch video How to group SharePoint list data by year using a calculated column online without registration, duration hours minute second in high quality. This video was added by user Nate Chamberlain 01 May 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 8,153 once and liked it 38 people.