Option 1- Basic Formulas
1
Click here.
2
Click here.
3
Add a field title.
4
Click here.
5
Click "Select field".
Formulas are based on fields within the project. Any numbers or dates.
6
Basic formulas can use add, subtract, multiply, and divide.
7
Select the second field needed for the formula.
8
Click here.
9
Click "Create field"
10
As you add numbers into the fields that the formula is using data from, the formula will adjust what is in the field you created.
In this example, the formula field is "Paid to Date".
Sums will also show up automatically at the bottom of a column once you begin adding numbers.
Formulas Below Number Columns
11
Asana automatically adds functions to the bottom of columns with numbers. You can change what function the column is using at any time by clicking on the function name, in this example you would click 'SUM".
12
The drop down will show 5 function options.
1) Sum
2) Average
3) Minimum
4) Maximum
5) Count
13
Each column function can be changed separately.
Option 2- Advanced Formulas
14
Click this icon.
15
Click "Formula"
16
Click "Switch to advanced mode"
17
Within this panel, you can add custom formulas using both functions and fields already within the project.
