# Formula custom field with Advanced Editor **URL:** \ **Category:** Product Updates\ **Created:** [1 August 2023 08:00 UTC](https://forum.asana.com/t/formula-custom-field-with-advanced-editor/481803 "2023-08-01T08:00:02Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Richard\_Sather](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/richard_sather/32/276096_2.png) [@Richard\_Sather](https://forum.asana.com/u/Richard_Sather)\ **Post date:** [1 August 2023 08:00 UTC](https://forum.asana.com/t/formula-custom-field-with-advanced-editor/481803/1 "2023-08-01T08:00:02Z")
Hi Asana community! 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](https://forum.asana.com/t/formula-basic-editor/438653). Today, I’m thrilled to announce you can now create more complex formulas with the new Formula custom field Advanced Editor! With this update, you can: - Create formulas using keyboard input - Point and click to build formulas - Use more than one operator (+, - , x, /) - Use #s (eg. field + field + field + 2) - Use Formula fields in Portfolios and Bundles ![f0c494deff82e9c30e27514009a49fdd95c535a9](https://us1.discourse-cdn.com/asana/original/3X/8/7/8701ba89a6d2aeb675fc852f76bb4c872f584689.png) 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: https://fast.wistia.net/embed/iframe/f99uacyt49 **For more details on the formulas shown in this video, check out my post [here](https://forum.asana.com/t/12-formulas-to-get-you-started-with-the-new-advanced-editor/495178).** 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](https://forum.asana.com/t/follow-our-news-category-to-keep-up-to-date-with-what-s-new-in-asana/87817)!_ ---
**Author:** ![Paul\_Grobler](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/paul_grobler/32/100608_2.png) [@Paul\_Grobler](https://forum.asana.com/u/Paul_Grobler)\ **Post date:** [1 August 2023 14:52 UTC](https://forum.asana.com/t/formula-custom-field-with-advanced-editor/481803/2 "2023-08-01T14:52:05Z")
I’m so excited about this update! ![OsitaOsitaIhemeGIF](https://us1.discourse-cdn.com/asana/original/3X/b/2/b2115cef630b133dad3bf7cbff9f34d204f15491.gif) ---
**Author:** ![Amy\_Johnson3](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/amy_johnson3/32/177755_2.png) [@Amy\_Johnson3](https://forum.asana.com/u/Amy_Johnson3)\ **Post date:** [2 August 2023 16:46 UTC](https://forum.asana.com/t/formula-custom-field-with-advanced-editor/481803/3 "2023-08-02T16:46:57Z")
Are the basic formula field and the Advanced Editor being rolled out separately? We seem to only have the basic formula field at this time. ---
**Author:** ![Larry\_Berger\_lpb](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/larry_berger_lpb/32/276017_2.png) [@Larry\_Berger\_lpb](https://forum.asana.com/u/Larry_Berger_lpb)\ **Post date:** [2 August 2023 16:58 UTC](https://forum.asana.com/t/formula-custom-field-with-advanced-editor/481803/4 "2023-08-02T16:58:06Z")
Welcome, @Amy_Johnson3, Yes, that’s right; Advanced Editor is being rolled out. Thanks, Larry ---
**Author:** ![G.White](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/g.white/32/291204_2.png) [@G.White](https://forum.asana.com/u/G.White)\ **Post date:** [4 August 2023 00:34 UTC](https://forum.asana.com/t/formula-custom-field-with-advanced-editor/481803/5 "2023-08-04T00:34:43Z")
This is not a moment too soon for us and an excellent increase in functionality! Hopefully the ability to use a formula field as an input to another formula field isn’t too far away (I did see it’s being worked on). ---
**Author:** ![Esteban\_Giannini](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/esteban_giannini/32/159690_2.png) [@Esteban\_Giannini](https://forum.asana.com/u/Esteban_Giannini)\ **Post date:** [4 August 2023 15:26 UTC](https://forum.asana.com/t/formula-custom-field-with-advanced-editor/481803/6 "2023-08-04T15:26:14Z")
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. Has anyone found a solution for this? ---
**Author:** ![Richard\_Sather](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/richard_sather/32/276096_2.png) [@Richard\_Sather](https://forum.asana.com/u/Richard_Sather)\ **Post date:** [4 August 2023 15:42 UTC](https://forum.asana.com/t/formula-custom-field-with-advanced-editor/481803/7 "2023-08-04T15:42:56Z")
Hi @Esteban_Giannini , it’s a great feature isn’t it? 😃 I’m not sure what your formula is exactly but perhaps try adding +0 on the end. This seemed to be a good workaround in some instances. Could you share a screenshot please? ---
**Author:** ![Esteban\_Giannini](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/esteban_giannini/32/159690_2.png) [@Esteban\_Giannini](https://forum.asana.com/u/Esteban_Giannini)\ **Post date:** [4 August 2023 15:59 UTC](https://forum.asana.com/t/formula-custom-field-with-advanced-editor/481803/8 "2023-08-04T15:59:54Z")
Hi @Richard_Sather - I have been trying different workarounds but it doesn’t seem to solve it. Here is a screenshot of the calculation: ![Screenshot 2023-08-04 at 11.48.40 AM](https://us1.discourse-cdn.com/asana/original/3X/0/1/01ea6ce5135221d336c2d429f4170d0cf9012fd1.png) Here is a screenshot of how it doesn’t calculate when there is an empty field: ![Screenshot 2023-08-04 at 11.50.53 AM](https://us1.discourse-cdn.com/asana/original/3X/e/b/eb8a6f6d36504515eb38ab99b6df659fe9ab3cce.png) ---
**Author:** ![Richard\_Uruchurtu](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/richard_uruchurtu/32/21828_2.png) [@Richard\_Uruchurtu](https://forum.asana.com/u/Richard_Uruchurtu)\ **Post date:** [4 August 2023 20:39 UTC](https://forum.asana.com/t/formula-custom-field-with-advanced-editor/481803/9 "2023-08-04T20:39:15Z")
If we could add IF or CASE statement’s to this I can replace so many tools with Asana. ---
**Author:** ![Tetsuo\_Kawakami](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/tetsuo_kawakami/32/84271_2.png) [@Tetsuo\_Kawakami](https://forum.asana.com/u/Tetsuo_Kawakami)\ **Post date:** [7 August 2023 11:08 UTC](https://forum.asana.com/t/formula-custom-field-with-advanced-editor/481803/10 "2023-08-07T11:08:38Z")
FYI I just found that we can display actual time in hours unit at dashboard # chart. ![image](https://us1.discourse-cdn.com/asana/original/3X/a/4/a455000422ed447084649510487b766ea08c54b2.png) ![image](https://us1.discourse-cdn.com/asana/original/3X/3/7/37410cfc75fa4c9cdcc6ab67b3ff07ff0303f6e1.png) just define for it in advanced editor below; ![image](https://us1.discourse-cdn.com/asana/original/3X/f/c/fce58e85f312d40e73321570359466d8c2f548d2.png) ---
**Author:** ![Richard\_Sather](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/richard_sather/32/276096_2.png) [@Richard\_Sather](https://forum.asana.com/u/Richard_Sather)\ **Post date:** [7 August 2023 17:00 UTC](https://forum.asana.com/t/formula-custom-field-with-advanced-editor/481803/11 "2023-08-07T17:00:22Z")
@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 @Richard_Uruchurtu , hopefully this is coming in the near future 🙏 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](https://forum.asana.com/t/number-formatting-of-estimated-time-in-charts-in-hours-instead-of-days/304502/19) for the complete workaround on getting dashboards to display in hours/days instead of weeks/days.** ---
**Author:** ![FenwayJohnny](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/fenwayjohnny/32/147211_2.png) [@FenwayJohnny](https://forum.asana.com/u/FenwayJohnny)\ **Post date:** [7 August 2023 18:54 UTC](https://forum.asana.com/t/formula-custom-field-with-advanced-editor/481803/12 "2023-08-07T18:54:52Z")
Damn… you guys are madmen! Cant wait to have this feature rolled out. ---
**Author:** ![Emily\_Roman](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/emily_roman/32/283076_2.png) [@Emily\_Roman](https://forum.asana.com/u/Emily_Roman)\ **Post date:** [8 August 2023 09:07 UTC](https://forum.asana.com/t/formula-custom-field-with-advanced-editor/481803/13 "2023-08-08T09:07:22Z")
Hi everyone! Formula custom field with Advanced Editor is now available to all Business and Enterprise customers 🎉 ---
**Author:** ![Emily\_Roman](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/emily_roman/32/283076_2.png) [@Emily\_Roman](https://forum.asana.com/u/Emily_Roman)\ **Post date:** [8 August 2023 09:08 UTC](https://forum.asana.com/t/formula-custom-field-with-advanced-editor/481803/14 "2023-08-08T09:08:44Z")
> [@Richard\_Sather](#): > > @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. @Richard_Sather I will check with our product team. I’ll share an update soon! 🙂 Update to comment → This is expected behaviour and you can follow updates when we solve it here: [Formula Field Not Working with Empty Fields](https://forum.asana.com/t/formula-field-not-working-with-empty-fields/500385) ---
**Author:** ![Scott\_Burkinshaw](https://luna1.co/8d76cd.png) [@Scott\_Burkinshaw](https://forum.asana.com/u/Scott_Burkinshaw)\ **Post date:** [8 August 2023 11:10 UTC](https://forum.asana.com/t/formula-custom-field-with-advanced-editor/481803/15 "2023-08-08T11:10:03Z")
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! ---
**Author:** ![Samantha\_Di\_Lullo](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/samantha_di_lullo/32/187112_2.png) [@Samantha\_Di\_Lullo](https://forum.asana.com/u/Samantha_Di_Lullo)\ **Post date:** [9 August 2023 13:09 UTC](https://forum.asana.com/t/formula-custom-field-with-advanced-editor/481803/16 "2023-08-09T13:09:56Z")
Great tool! Thank you for adding this! 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? ---
**Author:** ![Richard\_Sather](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/richard_sather/32/276096_2.png) [@Richard\_Sather](https://forum.asana.com/u/Richard_Sather)\ **Post date:** [10 August 2023 09:49 UTC](https://forum.asana.com/t/formula-custom-field-with-advanced-editor/481803/17 "2023-08-10T09:49:28Z")
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: > [@test\_tube 12 Formulas to get you started with the new Advanced Editor](https://forum.asana.com/t/12-formulas-to-get-you-started-with-the-new-advanced-editor/495178): > > Hi everyone! I hope you are all excited about the recent roll out of the Advanced Editor for Formula fields as I recently announced [here](https://forum.asana.com/t/formula-custom-field-with-advanced-editor/481803). That post includes a video where I had the chance to showcase various use cases, so I thought I’d create this post to share more details on how I built them, which will hopefully inspire you while you try out the Advanced Editor for Formula fields (rolling out on Business and Enterprise tiers). 1. Task Duration:white_check_mark Prerequisites: Start & Due … ---
**Author:** ![Richard\_Sather](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/richard_sather/32/276096_2.png) [@Richard\_Sather](https://forum.asana.com/u/Richard_Sather)\ **Post date:** [10 August 2023 09:52 UTC](https://forum.asana.com/t/formula-custom-field-with-advanced-editor/481803/18 "2023-08-10T09:52:04Z")
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. ---
**Author:** ![Samantha\_Di\_Lullo](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/samantha_di_lullo/32/187112_2.png) [@Samantha\_Di\_Lullo](https://forum.asana.com/u/Samantha_Di_Lullo)\ **Post date:** [10 August 2023 12:10 UTC](https://forum.asana.com/t/formula-custom-field-with-advanced-editor/481803/19 "2023-08-10T12:10:08Z")
Thank you! This sounds like it might be the solution for us. Is there a tutorial video on how to do this? ---
**Author:** ![Richard\_Sather](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/richard_sather/32/276096_2.png) [@Richard\_Sather](https://forum.asana.com/u/Richard_Sather)\ **Post date:** [10 August 2023 12:33 UTC](https://forum.asana.com/t/formula-custom-field-with-advanced-editor/481803/20 "2023-08-10T12:33:11Z")
@Samantha_Di_Lullo , here is a link to the guide article of how to map form questions to custom fields: > **[Create Forms in Asana | Product Guide • Asana Product Guide](https://asana.com/guide/help/premium/forms#gl-mapping)** > > Use Asana forms with internal and external teams, to collect and consolidate information. Feel free to DM me if you are interested in any training services and support. It’s what I do! 😃 [Next page](https://forum.asana.com/t/formula-custom-field-with-advanced-editor/481803.md?page=2)