if(dateBetween(now(), prop("Date"), "months") <= if(prop("Type of Meeting") == "Relationship", 12, if(prop("Type of Meeting") == "Prospecting", 6, if(prop("Type of Meeting") == "Event", 3, 0))), prop("Type of Meeting"), format(toNumber("")))
if(dateBetween(now(), prop("Date"), "months") <=
Check to see if the number of months between Date and the current date is less than or equal the following.
if(prop("Type of Meeting") == "Relationship", 12, if(prop("Type of Meeting") == "Prospecting", 6, if(prop("Type of Meeting") == "Event", 3, 0)))
If Type of Meeting is Relationship, set the number to 12
, if Prospecting set it to 6
, and so on.
prop("Type of Meeting"),
If the first number is less than or equal to the second one display the meeting type again.
format(toNumber("")))
If it's not display not (this will ensure an actual blank result).
length(replaceAll(replaceAll(prop("Types"), "Relationship", "*"), "[^*]", ""))
length(replaceAll(replaceAll(prop("Types"), "Prospecting", "*"), "[^*]", ""))
length(replaceAll(replaceAll(prop("Types"), "Event", "*"), "[^*]", ""))
if(prop("Relationship") < 1 or prop("Prospecting") < 1 or prop("Events") < 1, "Plan meeting", "")
<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>