I need help debugging my Notion formula. The section handling ‘Bestie’ and ‘Immediate Kin’ always outputs ‘Reconnect now!’ regardless of the record’s date. Revised code example below:
if((getProperty("GroupType") == "Acquaintance" or getProperty("GroupType") == "Associate" or getProperty("GroupType") == "Advisor") and timeDifference(now(), getProperty("LastMet"), "months") > 5, "Reconnect now!", if((getProperty("GroupType") == "Relative" or getProperty("GroupType") == "Old Friend") and timeDifference(now(), getProperty("LastMet"), "months") > 0, "Reconnect now!", if((getProperty("GroupType") == "Bestie" or getProperty("GroupType") == "Immediate Kin") and timeDifference(now(), getProperty("LastMet"), "weeks") > 1, "Reconnect now!", "👌")))
I have encountered a similar issue with my Notion formulas and found that sometimes the problem lies in how each conditional branch processes relative date calculations. I once had a formula dealing with multiple time units and it turned out the conversion between weeks and months wasn’t working as expected due to the nested structure. Separating the conditions helped isolate the problem. In my experience, simplifying the logic to verify each condition individually and then progressively merging them offers a clearer view of the root cause.
In my experience, similar issues with Notion formulas often come down to how conditions are evaluated. I discovered that sometimes the order of operations and the structure of nested if statements can cause unexpected behavior. In your case, the condition for ‘Bestie’ and ‘Immediate Kin’ may be improperly evaluated due to the way Notion handles logical OR within nested statements. Separating or testing each condition individually and then combining them helped me verify that each branch works as intended. Consider resetting and testing with simplified conditions to isolate the problematic part.