Is there a way to have the 30/60/90 day column auto populate based on the targeted due date?
We are looking to create tasks with due dates that gets sorted based on time increments.
We have a column that is a targeted due date, from there we want to have a column that sorts the tasks in 30/60/90 day buckets based on the current date. This will then allow us in card view to see the task at the time increments.
Is there a way to have the 30/60/90 day column auto populate based on the column of the targeted due date? For example, it would know the date today is 6/10 and if a task is estimated to be completed on 6/15 it would get categorized into the 30 Day category.