# Is there a way to have the 30/60/90 day column auto populate based on the targeted due date?

Options

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.

• ✭✭✭✭✭
edited 06/10/21
Options

Have a look at this for a bit of background on how I came up with the formula

If you want to highlight overdue with a -1

=IF(Date@row < TODAY(), "-1", IF(Date@row <= TODAY(30), 30, IF(Date@row <= TODAY(60), 60, 90)))

Otherwise

=IF(Date@row <= TODAY(30), 30, IF(Date@row <= TODAY(60), 60, 90))

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!