I’m trying to recreate this table in a workflow template.
So each row of data in Google Sheets will have a date. The user can choose a start date and end date via a form. To give an abbreviated list. The client then wants these grouping/summing and ordering by year then month. I know I may have to to create 2 virtual columns for Month() and Year().
The biggest issue is the start and end date could be chosen as 2 months or 50 months. So I cannot use virtual columns to do this. But AFAIK you cannot group items via a <<START: Select(… function.
Can anyone tell me its impossible or suggest how I could do this