🪲 Rules not triggering when 'Number is' condition is a formula field

[Richard_Sather]

Another issue related to triggers of formula fields here:

Date Formula to determine Midpoint

Hi @Abigail_Brizuela , I thought this should be possible so I gave it a whirl. Here is the end formula: [image] 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: [image] 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 , @Emily_Roman , I’m kindly asking for yet another escalation as this is a considerable loss of what should be considered expected functionality.
CC: @Julio_Buendia