I am using OOTB task list in Sharepoint online and looking to leverage group by feature on my tasks view to group by due date range. Due Date column contains date values tagged for each task.
So probably a calculated column can be added, which can be set to "Tasks due in next 7 days" for tasks due in next 7 days, then maybe "Tasks due in next 15 days" for tasks due in next 15 days. Then I can use this calculated column to do group by.
I guess in such case, there would be a requirement to store today's date in one of the date columns,so if needed, I can schedule a flow to run everyday and update this date column to today's date, maybe then this column and due date column can be used for comparison for calculated column value, just a thought for worse case scenario.
Can someone shed some light what would be the best way to achieve this, thanks in advance.