Entries
Status
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.
