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.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!