I’ve worked out how to use the formulas to created a custom field that subtracts the creation date of a task from the due date to generate an ‘age of project’ field. What I would really like to be able to do is the subtract the creation date from today’s date. Additionally, I’d like to be able to get a chart on my dashboard that summarises tasks that are 30/60/90/120+ days old to identify jobs that are taking too long. Being able to colour code the task tile or have some other indicator that shows overdue jobs would be good. Any tips please? Thanks
1 Like
Summoning Formula custom fields God @Richard_Sather 
Meanwhile, you might check this article, where you just might find some answers :
1 Like
Thanks @Arthur_BEGOU 
@Scott_Burkinshaw , you mention:
This is not currently available but hoping Asana will add the ‘today’ operation as a follow up to formulas. I’ll circle back here when that becomes a feature, hopefully soon 
Great, thanks!
2 Likes
Trello has a nice feature in which the task begins to visually decay if it sits unmodified for too long, like a piece of paper yellowing and fraying over a century. This would be a nice simple version of what’s being discussed in this thread, although probably would not meet Scott’s needs.
I don’t suppose the TODAY function has been added yet, has it? This solution would give me a meaningful reason to upgrade our plan.
We have very busy boards and am looking for ways to keep the ball rolling and minimising low priority tickets from going stale because they’re always out of view. A ‘Ticket Age’ field would be perfect for this.
Hi @Dennison_Packer ,
It actually has! You can check out @Richard_Sather 's post below for more info on usage:
1 Like