I am wanting to have a view in my To-Do list table that groups tasks by time they are overdue. So, I would like the groupings to be:
Overdue less than a week
Overdue between 1-2 weeks
Over 2 weeks overdue
I am thinking that I need to have a formula that calculates the total time that the date is “overdue”, and maybe use an IF formula to then classify the times, and then outputting a “category” (e.g. 1 week) that I can then group by.
Am I going in the right direction? Has this kind of thing been addressed before? I have searched and could not find anything directly related to this.