# 🪲 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:** 1\ **Showing post:** 11
**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 --- _[View the full topic](https://forum.asana.com/t/rules-not-triggering-when-number-is-condition-is-a-formula-field/1075875)._