Automation with Google Calendar - Event Date & Tim...

[Say-Chi]

I have three columns:

1. Email
2. Sent (Yes/No)
3. 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?

[Elias_Gomez_Sai]

Use DATETIME_DIFF():

Airtable - Support

Formula field reference

For an overview of formula fields, please refer to the Guide to Formula, Lookup, Count, and Rollup fields. Formulas may involve functions, numeric operations, logical operations, and text operation...

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.

[Say-Chi]

Thank you, managed to get it working. Yes, I agree. Thank you!

[David_Andoh]

Can you provide the solution?

[David_Andoh]

What was your solution here?

[XanthumChum]

I would just do:

TONOW({Date Sent})