Future automation based on time stamp

[Sasha_Moser]

Hi everyone. I need some help understanding if my logic is correct.
I am trying to create follow-up emails to be sent in the future 1 month, 3 months, 6 months - from the date they were added to the table. I am using a specific status as condition (e.g 1 month) + language condition + date added = number of days ago (e.g 30, 90 or 180).
Thank you in advance for your help.

[Justin_Barrett]

Welcome to the community, @Sasha_Moser! :grinning_face_with_big_eyes: Your logic looks pretty sound. Here’s one way to structure a formula that could be used to trigger an automation on those intervals:

IF(
    Status = "Desired Value",
    SWITCH(
        DATETIME_DIFF(NOW(), CREATED_TIME(), "days"),
        30, 1,
        90, 1,
        180, 1,
        0
    )
)

That will output a 1 at any of those three intervals after the record’s creation date, but only when a given status is matched. At all other times during the status match, the output will be zero. If the status isn’t matched, it will be blank.

If you want the automation to behave differently at each of those intervals—perhaps by using conditional branches in the automation to send different emails—you could move the DATETIME_DIFF() calculation to its own formula field so that the automation could have access to that value when triggered, and refer to that field in the above formula.