I’m Richard, an Asana Forum Leader and Asana Solutions Partner, here to share Asana’s latest update
Earlier this month, Asana launched Formula custom fields . Today, I’m thrilled to announce you can now create more complex formulas with the new Formula custom field Advanced Editor!
If you’d like to learn more about this new feature, check out the video below, where I deep dived into Formula custom field advanced editor, showcasing various use-cases:
For more details on the formulas shown in this video, check out my post here.
We hope you find this update useful! We look forward to reading all your use cases and the formulas you are planning to build with the Advanced editor. Let us know in the comments below!
Please note, this update is being gradually rolled out and it will be available to all Business and Enterprise customers soon.
Want to be automatically notified of all new upcoming product updates? Make sure to follow our News category!
This is an amazing update! I have been playing around with it and it opens so many new opportunities.
Just wanted to point out that as I was testing the advance editor I discovered that if one of the fields in a sum is empty, it will not perform the calculation. You have to replace the empty field with a 0 for it to perform the calculation.
This is something that you should definitely try to fix. The editor should assume that if a field is empty, it means 0.
@Esteban_Giannini , indeed this is the expected behaviour. You would have to input a 0 value instead of leaving it blank.
@Emily_Roman , perhaps you could raise this to the product team; whether a blank field could instead be considered as 0, or so we can better understand their reasons for this behaviour.
Hi @Tetsuo_Kawakami , nice hack! Also, I found that if you add a +0 on the end, you will get the result in minutes! And if you divide that by 60 then you will get the value in ‘numeric’ hours, i.e 10h30m will display as 10.5, as per below formula which you can copy paste into your advanced editor: ( [[$ACTUAL_TIME]] + 0 ) / 60
Refer to my post here for the complete workaround on getting dashboards to display in hours/days instead of weeks/days.
Hi - would it possible to multiply a number by a % using this feature please? We have tasks that carry a total deal value and have a separate field that indicates the % complete of the task. So it’d be good to be able to multiply one by the other to arrive at a current value of the job. Thanks!
On a similar note, can this be used in a form to tally response results.
For example, where the respondent has 4 options to choose from, each worth a distinct numerical value, and then once the form is submitted we get a tally of their score?
Hi @Scott_Burkinshaw , sure you can! For the formulas, simply replace your percentages with a decimal, so for example, 55% would be 0.55, or +55% would be 1.55
For example, if you want to get say 15% of one of your number field’s value (eg. your ‘Cost’ field), you would input in the formula advanced editor as such: [Cost field]*0.15 to give you the value of that 15%.
If you want the total value, i.e. your cost field + 15%, then you would input in the formula advanced editor as such: [Cost field]*1.15
You can also have a look at my post below, especially numbers 9-12 where I show examples applying tax or discounts:
Hi @Samantha_Di_Lullo , currently the feature does not support mapping dropdown custom fields (such as single-select or multi-select) to a number value. You could only achieve this if your form’s questions contained ‘number’ or ‘date’ type questions which could be mapped to relevant fields in your project, from which a formula field would be able to provide a tally score.
Want to be automatically notified of all new upcoming product updates? Make sure to 
Refer to my post 
