Latest Contact

Latest Contact

From
Reddit
Status
Done
Formulas

Last Contact

[prop("Last Met"), prop("Last Called"), prop("Last Texted")] .sort() .last()
Old Explanation
if(empty(prop("Last Met")) and empty(prop("Last Called")) and empty(prop("Last Texted")), fromTimestamp(toNumber("")),
If Last Met, Last Called, and Last Texted are empty, return a blank date.
fromTimestamp(max( ... ))
Otherwise get the largest timestamp from Last Met, Last Called, and Last Texted using this for each and convert it back to a proper date.
timestamp(if(empty(prop("Last Met")), fromTimestamp(0), prop("Last Met")))
If Last Met/Called/Texted is empty use 0 as the timestamp, otherwise convert the entered date.
 
By Ben  •  Latest  •  Was this helpful? Please consider buying me a coffee. Cheers!By Ben  •  Latest  •  Was this helpful? Please consider buying me a coffee. Cheers!
By BenLatest • Was this helpful? Please consider buying me a coffee. Cheers!