I have three columns:
- Sent (Yes/No)
- Date (Sent)
I would like to add a fourth col to display the number of days since the email was sent (i.e. Current Date - Date Sent, displayed as Days). How can I write a formula for that?
Use a Formula to Count Days Since Date (Event)
Use DATETIME_DIFF():
Also, I think you could remove the Sent field, cause you already have that information in Date field: if it is filled, it is send.
Use DATETIME_DIFF():
Also, I think you could remove the Sent field, cause you already have that information in Date field: if it is filled, it is send.
Thank you, managed to get it working. Yes, I agree. Thank you!
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.