12 Asana Formula Examples: Track Task Duration, Budgets, Costs & More

When working with formulas in Asana, knowing how to structure them correctly can significantly improve efficiency and accuracy in your workflows. Whether you're tracking project durations, budgets, or tax calculations, Asana’s formula fields allow you to automate key metrics with ease.

This post highlights practical Asana Formula Examples you can use across real-world scenarios — helping you transform Asana into a smart, data-driven workspace.

Asana offers two different ways to enter formulas:

• Basic Formula Editor – This allows for straightforward calculations using field names and mathematical operators.

• Advanced Editor – This uses variable placeholders (e.g., [[$DUE_DATE]], [[$ACTUAL_TIME]]) to reference Asana’s built-in fields, making it more flexible for automating calculations based on dates, times, and other system values.

  
  

In this guide, we’ll walk through some of the most useful Asana Formula Examples — covering everything from task duration and budgeting to cost calculations with discounts and tax. Let’s dive in!

Asana Formula Examples for Time, Budget, and Cost Automation

1. Task Duration

Prerequisites:

• Every task has both a Start Date and a Due Date set.

1.1: Task Duration in Days

((Due date-Start date)/1440)+1 = Duration 

Advanced Editor Version:

(( [[$DUE_DATE]] - [[$STARTED_AT]] ) / 1440) + 1

What it does:

• Calculates the total number of days a task will take.

• Divides by 1440 (the number of minutes in a day).

• Adds 1 so that a task covering only one day still counts as 1 day.

1.2: Task Duration in Hours (with decimals)

((Due date - Start date) + 0) / 60

Advanced Editor Version: 

( ( [[$DUE_DATE]] - [[$STARTED_AT]] ) + 0 ) / 60

What it does:

• Converts the task duration into hours (including decimals).

• Divides by 60 to convert minutes into hours.

• The +0 ensures the calculation runs correctly (it does not change the value).

1.3: Task Duration in Whole Hours (No Decimals)

((Due date - Start date) / 1440) + 1 * 24

Advanced Editor Version:

( ( [[$DUE_DATE]] - [[$STARTED_AT]] ) / 1440 + 0 ) * 24

What it does: 

• Calculates the total hours a task will take, but without decimals.

• Uses 1440 (minutes in a day) to determine full-day durations.

• Multiplies by 24 to convert days into whole hours.

  
  

1.4: Task Duration in Workdays (Decimals)

((Actual time) + 0) / 60 / 7

Advanced Editor Version: 

( [[$ACTUAL_TIME]] + 0 ) / 60 / 7

What it does:

• Converts actual time logged into workdays.

• Divides by 60 to get hours.

• Further divides by 7 (assuming a 7-hour workday).

Tip:

• If a task only has a Due Date (no Start Date), the formulas will not correctly display "1 day."

  • Workaround: Always enter a Start Date (even if it’s the same as the Due Date).

2. Project Duration in days (for Portfolios)

Prerequisites:

• Your projects must have both a Start Date and an End Date.

  • ⚠️ In Portfolios, the Due Date is referred to as ‘Date’.

    
    

1.1 Project Duration in Days

0 + (Date - Start Date) / 1440

Advanced Editor Version:

0 + ( [[$DATE]] - [[$STARTED_AT]] ) / 1440

What it does:

• Calculates the total project duration in days.

• Divides by 1440 to convert minutes into days.

• The +0 ensures the calculation remains valid.

  
  

1.2 Displaying Project Duration in Weeks & Days

The native ‘Duration’ field in Portfolios only shows total days. This method improves readability by breaking it into weeks and days.

Date - Start Date

3. Project Daily/Weekly Budget (for Portfolios)

Prerequisites:

• Your projects must have both a Start Date and an End Date.

• The ‘Date’ field in your Portfolio should be populated.

• Your project includes an ‘Estimated Budget’ field (set as a currency-type number).

  
  

2.1 Calculating the Daily Budget

Estimated budget / ((Date - Start Date) / 1440)

What it does:

• Divides the total estimated budget by the total project duration in days.

• 1440 converts minutes into days.

• Provides an estimated daily spend rate.

  
  

2.2 Calculating the Weekly Budget

Estimated budget / ((Date - Start Date) / 1440) * 7

What it does:

• Uses the daily budget formula and multiplies it by 7 to get the weekly budget.

• The 7 represents a full week, but you can replace it with 5 if calculating based on a workweek.

4. Remaining Project Budget (for Portfolios)

Estimated budget - Actual spent

Prerequisites:

• Your projects must have an ‘Estimated Budget’ field (set as a currency-type number).

• Your projects must also have an ‘Actual Spent’ field (set as a currency-type number).

5. Setting the Estimated Budget Based on the Daily Budget (for Portfolios)

Daily budget * (Date - Start Date) / 1440

Prerequisites:

• Your projects must have both a Start Date and an End Date.

• The ‘Date’ field in your Portfolio should be populated.

• Your project includes a ‘Daily Budget’ field (set as a currency-type number).

Tip:

• To ensure the Estimated Budget retains accurate decimal values, set the ‘Daily Budget’ currency field to two decimal places.

6. Converting Story Points to Estimated Hours

Story Points * 8

Prerequisites:

• Your project must have a ‘Story Points’ custom field (set as a number field).

What it does:

• Multiplies Story Points by 8 (assuming 1 Story Point = 8 hours, or one full workday).

• Provides an estimated number of hours required for a task based on Story Points.

Tip:

• To ensure the Estimated Hours retains accurate decimal values, set the ‘Story Points’ number field to two decimal places.

7. Converting Story Points to Hours Remaining

(Story Points * 8) - (Actual Time / 60)

Prerequisites:

• Your project must have a ‘Story Points’ custom field (set as a number field).

• You must be using Asana’s native ‘Actual Time’ field.

What it does:

• Multiplies Story Points by 8 (assuming 1 Story Point = 8 hours, or one full workday).

• Converts ‘Actual Time’ (stored in minutes) into hours by dividing by 60.

• Subtracts the actual logged time from the estimated hours to determine the remaining hours.

Tip:

• To ensure the Estimated Hours Remaining retains accurate decimal values, set the ‘Story Points’ number field to two decimal places.

8. Calculating Cost Based on Hourly Rate and Actual Time

Hourly Rate * (Actual Time / 60)

Prerequisites:

• Your project must have a ‘Hourly Rate’ custom field (set as a currency-type number field).

• You must be using Asana’s native ‘Actual Time’ field.

What it does:

• Converts ‘Actual Time’ (stored in minutes) into hours by dividing by 60.

• Multiplies the Hourly Rate by the total logged hours to determine the cost of work done.

Tip:

• You do not need to add two decimal places to the ‘Hourly Rate’ field, as the resulting currency will already be formatted to two decimal places.

9. Calculating Total Cost Including Tax

(Hourly Rate * (Actual Time / 60)) * 1.24

Prerequisites:

• You must have a ‘Hourly Rate’ custom field (set as a currency-type number field).

• You must be using Asana’s native ‘Actual Time’ field.

What it does:

• Converts ‘Actual Time’ (stored in minutes) into hours by dividing by 60.

• Multiplies the Hourly Rate by the total logged hours to determine the base cost.

• Applies a 24% tax by multiplying by 1.24 (adjust the multiplier for different tax rates).

Tip:

• You do not need to add two decimal places to the ‘Hourly Rate’ field, as the resulting currency will already be formatted to two decimal places.

10. Calculating the Value of Added Tax (VAT)

(Hourly Rate * (Actual Time / 60)) * 0.24

Prerequisites:

• Any formula that includes a currency-type number field (e.g., Hourly Rate, Cost, or Total Cost).

• This formula calculates only the tax amount, separate from the total cost

Tip:

• You do not need to add two decimal places to the ‘Hourly Rate’ field, as the resulting currency will already be formatted to two decimal places.

11. Calculating Total Cost with Quantity, Discount, and Tax

Prerequisites:

• A ‘Cost per Item’ custom field (set as a currency-type number field).

• A ‘Quantity’ custom field (set as a number field).

• At least one of these fields should be set to two decimal places for accuracy.

11.1 Calculating Cost with Discount Applied

Example with 10% Discount):

(Cost per Item * Quantity) * 0.9

What it does:

• Multiplies the cost per item by the quantity to get the total price.

• Applies a discount by multiplying by 0.9 (representing a 10% discount).

  • Use 0.5 for a 50% discount.

  • Use 0.1 for a 90% discount.

    
    

11.2 Calculating the Value of Added Tax After Discount

(Cost per Item * Quantity) * 0.9 * 0.24

What it does:

• Uses the discounted total from the first formula.

• Multiplies by 0.24 (representing 24% tax).

• Returns only the tax amount added after the discount.

  
  

11.3 Calculating the Final Cost Including Tax After Discount

Formula:

(Cost per Item * Quantity) * 0.9 * 1.24

What it does:

• Uses the discounted total from the first formula.

• Multiplies by 1.24 (representing the total cost including 24% tax).

• Returns the final price after discount and tax.

Tip:

• To ensure the final cost retains accurate decimal values, set the ‘Cost per Item’ currency field to two decimal places.

12. Calculating Total Cost Based on Area, Discount, and Tax

Example with 10% Discount:

(Cost per Coverage * Area) * 0.9

Prerequisites:

• A ‘Cost per Coverage’ custom field (set as a currency-type number field).

• An ‘Area’ custom field (set as a number field, representing sqft or m²).

• At least one of these fields should be set to two decimal places for accuracy.

What it does:

• Multiplies the cost per coverage unit by the area size to determine the base cost.

• Applies a discount by multiplying by 0.9 (representing a 10% discount).

  • Use 0.5 for a 50% discount.

• Use 0.1 for a 90% discount.

Tip:

• Remove any custom labels (such as ‘sqft’ or ‘m²’) from the ‘Area’ field.

• Ensure the ‘Cost per Coverage’ field is a currency-type field so the resulting formulas display correctly.

Wrapping Up: Make the Most of These Asana Formula Examples

By leveraging these Asana Formula Examples, you can streamline calculations, automate data tracking, and reduce manual effort across your projects. Whether you're managing task durations, budgets, or resource planning, these formulas turn Asana into a powerful, data-driven tool.

When implementing these formulas, remember to:

• ✅ Choose the right formula editor (Basic or Advanced) based on your needs.

• ✅ Set up prerequisite fields correctly to ensure accurate calculations.

• ✅ Adjust tax rates, work hours, or discount values to match your organization’s requirements.

  
  

With these formulas in place, your Asana projects will run smoother, smarter, and more efficiently—giving you more time to focus on meaningful work. 🚀

Got a formula you love using in Asana? Or a use case you’d like help with? Let me know in the comments — I’d love to hear how you’re using formulas!

P.S. This blog post is adapted from a forum post I originally shared here. If you’re active in the community, feel free to join the conversation there too!