Use a formula to calculate percent complete

[amykalra]

Hello,

Quick question. I have a field that calculates no. of days before start of a workshop. This is the formula I'm using- 

DATETIME_DIFF({Start Date/Time}, NOW(),'days').

I now want to create a field that calculates number of days 'after' a workshop. I want to use this for an automation. So for eg: if days after training completion =7, send email. What formula can I use here? I tried using a dateadd formula but I'm getting it wrong.

Thank you 🙂

[Sho · Accepted solution]

This formula will output 1 after 7 days of the date.
How about triggering an automation that sends an email when it reaches 1?

IF(DATETIME_DIFF(DATEADD({Date},7,'Days'), TODAY(),'days')=0,1)

Now() includes time, so there may be time differences. Today() is date only.

[amykalra]

Thank you so much!