求助修复Notion多条件if公式：密友与直系亲属判断异常

云原生阿岚

2026-7-28

解决Notion联系人跟进提醒公式的逻辑错误

你的问题出在逻辑运算符的优先级上：Notion公式中OR的优先级低于AND，导致第三个IF分支的条件被错误解析。

原公式里的这段：

prop("Association") == "Best Friends" or prop("Association") == "Immediate Family" and dateBetween(now(), prop("Last Contacted"), "weeks") > 1

实际会被解读为：

prop("Association") == "Best Friends" OR (prop("Association") == "Immediate Family" AND dateBetween(...) > 1)

也就是说，只要关联类型是「Best Friends」，不管Last Contacted的日期是什么，都会直接触发「Time to check in!」。

修正后的公式

把每个关联类型的OR条件用括号包裹，确保先判断关联类型分组，再检查日期间隔：

if(
  (prop("Association") == "Friend" or prop("Association") == "Professional" or prop("Association") == "Mentor") and dateBetween(now(), prop("Last Contacted"), "months") > 5,
  "Time to check in!",
  if(
    (prop("Association") == "Family" or prop("Association") == "Life-long Friend") and dateBetween(now(), prop("Last Contacted"), "months") > 0,
    "Time to check in!",
    if(
      (prop("Association") == "Best Friends" or prop("Association") == "Immediate Family") and dateBetween(now(), prop("Last Contacted"), "weeks") > 1,
      "Time to check in!",
      "👍"
    )
  )
)