Get Month and Year and Group/Sort
I've got a sheet in which sales reps input their daily activity. This sheet has a date column that is required. I'm trying to make a dashboard to track month to month levels of activity. Perhaps I'm missing something but there doesn't seem an obvious way to do this. I've tried making a report to group by month and sorts properly but I haven't been successful. The way I've done this is make a helper column in the report of =YEAR(DATE@row) + "/" + MONTH@row however when it gets to sorting 2021/9 ends up below 2021/12, I'm assuming because its sorting them as strings rather than recognizing them as dates. Any tips would be greatly appreciated!