Help

Group Overdue Tasks by Period of Time

Topic Labels: Base design
1609 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Nate_Sheets
6 - Interface Innovator
6 - Interface Innovator

Hi there!

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.

1 Reply 1

Right, you’re going in the right direction! :slightly_smiling_face:

Just create a formula field that results in different words or phrases or emojis, depending on how overdue that to-do item is.

Then, you can simply group by that formula field.