if(empty(prop("Last Spoke")), "", if(dateBetween(now(), prop("Last Spoke"), "months") >= prop("Contact Every # Months"), "🤗 Time to reach out", "👍 All good"))
if(empty(prop("Last Spoke")), "",
Check to see if Last Spoke is empty, and if it is display nothing.
if(dateBetween(now(), prop("Last Spoke"), "months") >= prop("Contact Every # Months"),
Otherwise, check to see if the number of months between the current date and Last Spoke is equal to or greater than the number entered in Contact Every # Months.
"🤗 Time to reach out",
If it is, display 🤗 Time to reach out.
"👍 All good"))
Otherwise display 👍 All good.
<aside> <img src="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" alt="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" width="40px" /> By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!
</aside>