If you want to use grouping on a list and it is a calculated column then you need to be careful which formula you put in the calculated column. It is best to use an IF statement. For examples:
- Grouping on a column with the following formula =TEXT([Date of Hours],”yyyy”) may cause problems with viewing items in the grouped view
- Instead use and if statement like the following =IF(ISBLANK(Date of Hours),”Missing Date”,TEXT(Date of Hours,”yyyy”)) and it seems to work better with grouping.
Stratacollab Consulting 