Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
May 17, 2020 12:48 PM
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.
May 17, 2020 01:03 PM
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.