The Today input is finally here!
Below are some handy formulas which you can copy/paste into the Advanced Formula editor, available for Asana Business/Advanced tier and above.
Alternatively, you can use this link to import a project, that contains all these formulas, into your Asana space.
Hack to use formulas with the Today input in Portfolios, until it is becomes available…
To use the below formulas in a Portfolio, first create the formula field in a project, then add it to your field library and then add that field to your portfolio by searching for it in your library.
1. Time spent from creation date, up until today
Calculate the time between the task’s creation date in relation to today.
You can replace CREATED ON with any date field such as employee’s start date (see #5 below) or birthday (see #6 below) or the native ‘Start date’ input.
Result in #d #h format or, if value is greater than a week, in #w #d
[[$TODAY]]-[[$CREATED_ON]]
Result in number of days in decimal format
( ( [[$TODAY]]-[[$CREATED_ON]] ) + 0 ) / 1440
Result in number of months in decimal format
( ( [[$TODAY]]-[[$CREATED_ON]] ) + 0 ) / 43920
Result in number of years in decimal format
( ( [[$TODAY]]-[[$CREATED_ON]] ) + 0 ) / 525960
2. Time remaining from today, until due date
Calculate the time between the task’s due date in relation to today.
Result in #d #h format or, if value is greater than a week, in #w #d
[[$DUE_DATE]] - [[$TODAY]]
Result in number of days in decimal format
( ( [[$DUE_DATE]] - [[$TODAY]] ) + 0 ) / 1440
Result in number of months in decimal format
( ( [[$DUE_DATE]] - [[$TODAY]] ) + 0 ) / 43920
Result in number of years in decimal format
( ( [[$DUE_DATE]] - [[$TODAY]] ) + 0 ) / 525960
3. Planned percentage of completion, up until today
Calculate the percentage a task or a project is completed, based on it’s start date & due date, in relation to today.
Result in number with decimal format
100 - ( [[$DUE_DATE]] - [[$TODAY]] ) * 100 / ( [[$DUE_DATE]] - [[$STARTED_AT]] )
until formatting the result of formulas is available, it’s a good idea to call this field “% Planned complete”, i.e. include the % at the start/end of the field title.
4. Planned budget spent, up until today
Calculate the budget that should have been spent up until today, assuming that budget is spent linearly between a task or project’s start date and due date.
Formula is as per above formula, but instead of 100, replace it with your ‘Budget’ field.
Result in currency (or just a number with 2 decimals, if using a custom currency for your Budget field)
Budget - ( [[$DUE_DATE]] - [[$TODAY]] ) * Budget / ( [[$DUE_DATE]] - [[$STARTED_AT]] )
5. Employee’s time employed, up until today
Calculate how many years an employee has been at your company. This formula is similar to #1 above but you simply replace CREATED_ON with a date field, let’s call it ‘First day’ (at work).
Result in number of years in decimal format
( ( [[$TODAY]]- First day ) + 0 ) / 525960
if you want the result in days or months, follow the same logic as per the other formulas in #1 above.
6. Person’s age, up until today
Calculate a person’s age based on a dedicated date field for their birthday. This formula is similar to #1 above but you simply replace CREATED_ON with a date field, called ‘Birthday’.
Result in number of years in decimal format
( ( [[$TODAY]]- Birthday ) + 0 ) / 525960
if you want the result in days or months, follow the same logic as per the other formulas in #1 above.
See all of my top tips & tricks on my website.