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
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!