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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!