# šŸŖ² Rules not triggering when 'Number is' condition is a formula field **URL:** \ **Category:** Closed\ **Created:** [28 June 2025 06:53 UTC](https://forum.asana.com/t/rules-not-triggering-when-number-is-condition-is-a-formula-field/1075875 "2025-06-28T06:53:19Z")\ **Posts on this page:** 16\ **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:** [28 June 2025 06:53 UTC](https://forum.asana.com/t/rules-not-triggering-when-number-is-condition-is-a-formula-field/1075875/1 "2025-06-28T06:53:19Z")
[@Forum-team](https://forum.asana.com/groups/forum-team) , I kindly ask that you escalate this issue to the product team to have a look - this one is definitely in the ā€˜not expected behaviourā€™ category šŸ˜¬ Not sure whether the introduction of (the very useful) formatting feature within formulas has caused this to break, or it was always the case but I will try and explain as best as possible in order for you to recreate, test, and hopefully fix since the use cases are numerous! šŸ™ One use case is to set a single-select field called ā€˜Statusā€™ to display whether a task/milestone is ā€˜On trackā€™ or ā€˜Off trackā€™, based on whether the taskā€™s due date has shifted compared to itā€™s ā€˜baselineā€™ (a date field). This rule would leverage a formula field called ā€˜Varianceā€™ that would look like this, giving us an output in ā€˜daysā€™. ![image](https://us1.discourse-cdn.com/asana/original/4X/e/0/a/e0a6b867c8fd5656dbeb55b8ae0e04f50aac045f.png) Below is the rule using the ā€˜Number isā€™ condition to simply change the single-select fieldā€™s options. Looks fine, right? Well it doesnā€™t run at all šŸ˜• ![image](https://us1.discourse-cdn.com/asana/original/4X/3/8/c/38ca40cb1863c44d471ee5e2fbc318357cbd9055.png) However, the rule runs perfectly fine when I replace the formula field with a simple number field. So my hunch is that there is something not working correctly with formula fields. I think the problem is in the way my ā€˜Varianceā€™ formula field is written - it basically converts the native weeks/days output into minutes (by using the +0) and then divides the minutes within a day (1,440) to get the output in days, formatted as such (which I donā€™t think is the problem): ![image](https://us1.discourse-cdn.com/asana/original/4X/e/0/a/e0a6b867c8fd5656dbeb55b8ae0e04f50aac045f.png) ![image](https://us1.discourse-cdn.com/asana/original/4X/a/e/a/aea40db4e52bd29bc68ac1482052b691c9d49c63.png) Call this a hacked formula? Side note, the API reveals that the values of the formula field are whole numbers and nothing strange between the `display value` and `number value`. Iā€™ve noticed that if you create such as formula (which includes dates) but _without_ applying the formatting immediately (before you hit ā€˜Create fieldā€™) then you will not be able to format it later. This is what you see if you try to format later, or if you try and format a simple `Due date` - `Today` formula upon creation: ![image](https://us1.discourse-cdn.com/asana/original/4X/c/9/5/c956aac08523ddf0f7baad45691c84e9cfb5222b.png) **Note, such formulas are not available in a Ruleā€™s ā€˜Number isā€™ condition. So at this point, Iā€™m thinking perhaps Iā€™ve done something Asana does not want me to - Iā€™ve made a ā€˜hackedā€™ formula (that contains date fields), available to be used in the ā€˜Number isā€™ condition of a rule. But my argument is, since Asana lets me format the formula into a ā€˜number of daysā€™ value, then why not let me use this number in the check if ā€˜Number isā€™ condition in the rule?** It would be awesome if it could! Please donā€™t tell me this is expected behaviour šŸ™ **Further testing:** I even tried to place the ā€˜Varianceā€™ formula into another formula and instead use that in the rule, but neither that worked with the rule. ![image](https://us1.discourse-cdn.com/asana/original/4X/6/8/4/6844b174d393929748b19d0f5f934c0e937df3af.png) I also tried a simple formula field with a fixed number as per below - the rule triggered correctly each time I changed the formula, concluding that it is not formula fields in general, only my particular ā€˜hackedā€™ formula: ![image](https://us1.discourse-cdn.com/asana/original/4X/1/a/2/1a2ae11b4a3efa6bd1adb143902f018ced999058.png) I started getting somewhere when I tried adding more ā€˜Whensā€™ and changed the conditions to include an ā€˜otherwiseā€™ instead and this actually worked, but only once, when the variance value was initially set/populated. After the variance field (and status field) was set, the rule did not seem to run again. šŸ˜• ![image](https://us1.discourse-cdn.com/asana/original/4X/8/e/d/8edba63e70a54891f6654c6dbc174d6c4b0aa227.png) And strangely enough, the above rule worked perfectly when the ā€˜Baseline dateā€™ (date field) was changed (but not when the Due date field is changed). So is there something wrong with the due date updating the formula fieldā€™s value or triggering the rule?! šŸ¤Æ Something is definitely not right šŸ˜¬ **Ideal solve:** Clearly, this would all be solved if I didnā€™t need to create this ā€˜hackedā€™ formula field and instead Asana would allow formatting of formulas that contain any date related fields, including created on, today, etc. so that they can be used in the ā€˜Number isā€™ condition of rules. ---
**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:** [28 June 2025 14:05 UTC](https://forum.asana.com/t/rules-not-triggering-when-number-is-condition-is-a-formula-field/1075875/2 "2025-06-28T14:05:38Z")
Something seems fishy and you certainly did a thorough job laying it out as best you could. I hope it will be escalated and can be improved, because this would be useful and until addressed will continue to trip up others similarly. Thanks, Larry ---
**Author:** ![Alex\_Christensen](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/alex_christensen/32/105044_2.png) [@Alex\_Christensen](https://forum.asana.com/u/Alex_Christensen)\ **Post date:** [30 June 2025 17:20 UTC](https://forum.asana.com/t/rules-not-triggering-when-number-is-condition-is-a-formula-field/1075875/3 "2025-06-30T17:20:13Z")
Hello @Richard_Sather and @Larry_Berger_lpb - I have gone ahead and reported this as a bug to our team. I will respond once I have heard back from the team. ---
**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:** [15 July 2025 06:39 UTC](https://forum.asana.com/t/rules-not-triggering-when-number-is-condition-is-a-formula-field/1075875/4 "2025-07-15T06:39:01Z")
Hi @Alex_Christensen , thank you for reporting this to the team. I take it you have not received any feedback yet? ---
**Author:** ![Alex\_Christensen](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/alex_christensen/32/105044_2.png) [@Alex\_Christensen](https://forum.asana.com/u/Alex_Christensen)\ **Post date:** [15 July 2025 15:24 UTC](https://forum.asana.com/t/rules-not-triggering-when-number-is-condition-is-a-formula-field/1075875/5 "2025-07-15T15:24:17Z")
Hello @Richard_Sather, I have not heard anything back as of yet. I have the task saved and will update once the team has information to share. ---
**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:** [15 November 2025 07:57 UTC](https://forum.asana.com/t/rules-not-triggering-when-number-is-condition-is-a-formula-field/1075875/6 "2025-11-15T07:57:14Z")
Hi [@Forum-team](https://forum.asana.com/groups/forum-team) , just checking in case we have any updates? This is a serious bug and is breaking workflows and big gap in the ā€˜Number isā€™ condition, making formula fields unusable. They appear to trigger when the number is _set_ but not when it is _changed_. Thanks! ---
**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:** [15 December 2025 07:23 UTC](https://forum.asana.com/t/rules-not-triggering-when-number-is-condition-is-a-formula-field/1075875/7 "2025-12-15T07:23:47Z")
Hi [@Forum-team](https://forum.asana.com/groups/forum-team) , kindly asking for this to be escalated again and looking for an update. This bug is painful and has broken several workflows that previously worked absolutely fine. In essence, when a formula field is changed it does no longer trigger a rule šŸ˜• Cc @Garrett_Knoll (I know itā€™s not your area, but hoping you can push this along!) ---
**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:** [15 December 2025 11:15 UTC](https://forum.asana.com/t/rules-not-triggering-when-number-is-condition-is-a-formula-field/1075875/8 "2025-12-15T11:15:18Z")
Thanks for following up again, @Richard_Sather. Youā€™re right to be frustrated. This is a known issue, and we havenā€™t done a good job of keeping you updated or moving it forward yet. Iā€™ve flagged it again with the team and asked for clarity on prioritization, and Iā€™ll keep you informed as we learn more. ---
**Author:** ![Adam-Involute](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/adam-involute/32/175240_2.png) [@Adam-Involute](https://forum.asana.com/u/Adam-Involute)\ **Post date:** [20 January 2026 14:52 UTC](https://forum.asana.com/t/rules-not-triggering-when-number-is-condition-is-a-formula-field/1075875/9 "2026-01-20T14:52:58Z")
Lots of great recording, @Richard_Sather . I found this thread while looking for issues related to ā€œNumber field is changedā€ rule trigger not triggering when the field is a formula. Definitely buggy. ---
**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:** [20 January 2026 20:01 UTC](https://forum.asana.com/t/rules-not-triggering-when-number-is-condition-is-a-formula-field/1075875/10 "2026-01-20T20:01:04Z")
Thanks, @Adam-Involute. Hoping this can get patched up soon! šŸ¤ž ---
**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:** [19 April 2026 08:36 UTC](https://forum.asana.com/t/rules-not-triggering-when-number-is-condition-is-a-formula-field/1075875/11 "2026-04-19T08:36:19Z")
Another issue related to triggers of formula fields here: > [@Date Formula to determine Midpoint](https://forum.asana.com/t/date-formula-to-determine-midpoint/1136618/6): > > Hi @Abigail_Brizuela , I thought this should be possible so I gave it a whirl. Here is the end formula: You can try to copy/paste this into the Advanced editor: [[$DATESUBTRACT\_FUNCTION]]([[$DUE\_DATE]], (([[$DUE\_DATE]] - [[$STARTED\_AT]]) / 2)) If you get an error, you may need to build this and two steps to ā€˜foolā€™ Asana. First create this formula and save it: Then Edit the formula and replace the 1 with ((Due date-start date)/2), like the first image. Here it is in actā€¦ Essentially, when a trigger is a formula field which is formatted as a date, it does not trigger a rule when that date value is simply changed. [@Forum-team](https://forum.asana.com/groups/forum-team) , @Emily_Roman , Iā€™m kindly asking for yet another escalation as this is a considerable loss of what should be considered expected functionality. CC: @anon60272785 ---
**Author:** ![Iren\_Vilaniso](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/iren_vilaniso/32/283891_2.png) [@Iren\_Vilaniso](https://forum.asana.com/u/Iren_Vilaniso)\ **Post date:** [24 April 2026 13:44 UTC](https://forum.asana.com/t/rules-not-triggering-when-number-is-condition-is-a-formula-field/1075875/12 "2026-04-24T13:44:09Z")
Hi @Richard_Sather , weā€™re currently looking into this and will keep you updated as we make progress. Thank you! ---
**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:** [5 May 2026 09:03 UTC](https://forum.asana.com/t/rules-not-triggering-when-number-is-condition-is-a-formula-field/1075875/13 "2026-05-05T09:03:41Z")
Hi @Richard_Sather, thanks for looping us in on this bug report, and apologies for the delay! I wanted to share an update: our product and engineering teams have investigated the issue and it has been officially triaged. While we donā€™t have a specific resolution date yet, a fix is currently in progress. We are prioritizing this and will keep you posted on our progress. Huge shoutout to @Nadeen_Saleh for helping drive this forward internally! ā¤ ---
**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:** [5 May 2026 19:48 UTC](https://forum.asana.com/t/rules-not-triggering-when-number-is-condition-is-a-formula-field/1075875/14 "2026-05-05T19:48:45Z")
Awesome, thanks @Emily_Roman and @Nadeen_Saleh! ---
**Author:** ![Nadeen\_Saleh](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/nadeen_saleh/32/283677_2.png) [@Nadeen\_Saleh](https://forum.asana.com/u/Nadeen_Saleh)\ **Post date:** [20 May 2026 23:43 UTC](https://forum.asana.com/t/rules-not-triggering-when-number-is-condition-is-a-formula-field/1075875/15 "2026-05-20T23:43:22Z")
Hi @Richard_Sather! We just pushed a fix for this yesterday, please let us know if you continue to see any issues šŸ™ ---
**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:** [21 May 2026 16:42 UTC](https://forum.asana.com/t/rules-not-triggering-when-number-is-condition-is-a-formula-field/1075875/16 "2026-05-21T16:42:23Z")
YES YES YES! Not only these rules are working, by being triggered by formula fields, but they are also **blazingly** fast!! Fantastic work, @Nadeen_Saleh and team - you guys rock ā¤