I’m working on a Notion database to manage my contacts and follow-up reminders. The idea is to set different check-in intervals based on the type of relationship. My formula works for most categories but fails for “Best Friends” and “Immediate Family”.
Here’s my current formula:
if((prop("Relationship") == "Acquaintance" or prop("Relationship") == "Colleague" or prop("Relationship") == "Advisor") and dateBetween(now(), prop("Last Interaction"), "months") > 5, "Reach out!", if(prop("Relationship") == "Extended Family" or prop("Relationship") == "Childhood Friend" and dateBetween(now(), prop("Last Interaction"), "months") > 0, "Reach out!", if(prop("Relationship") == "Close Friends" or prop("Relationship") == "Core Family" and dateBetween(now(), prop("Last Interaction"), "weeks") > 1, "Reach out!", "All good")))
The issue is that for “Close Friends” and “Core Family”, it always says “Reach out!” regardless of the “Last Interaction” date. I tried changing the time unit to “months” like the other conditions, but it didn’t help. Any ideas on what I’m doing wrong?
I’ve encountered similar issues with complex Notion formulas. One thing that jumps out is the nested ‘if’ statements - they can be tricky to manage. Have you considered using a ‘switch’ statement instead? It might make your logic clearer and easier to debug.
Also, I noticed your date comparisons are inconsistent. For some relationships, you’re using months, and for others, weeks. This could be causing unexpected behavior. Try standardizing your time units across all conditions.
Lastly, double-check your boolean logic. The ‘and’ operator in your ‘Close Friends’ and ‘Core Family’ condition might be causing it to always evaluate as true. You might need to adjust your parentheses to group the conditions correctly.
Hope this helps point you in the right direction. Notion formulas can be a beast, but once you get them right, they’re incredibly powerful!
I’ve dealt with similar Notion formula headaches before. Your approach is solid, but the execution needs tweaking. The main issue lies in your boolean logic and parentheses placement. For ‘Close Friends’ and ‘Core Family’, try restructuring like this:
This ensures the date comparison only happens when the relationship condition is met. Also, consider using a ‘switch’ statement or separate formulas for each relationship type to improve readability and debugging. Standardizing time units across all conditions might help too. Keep at it!
hey nova, ur formula looks messy AF. try splitting it into smaller parts maybe? like make separate formulas for each relationship type n then combine em. that way u can check each bit easier. also double check ur parentheses, sometimes those lil buggers mess everything up. good luck!