Send email reminder 5 days before each different date columns

[casitasrd]

Hello there,
I’m trying to send an email to my clients 5 days prior to each specific dates in each column in the same data table. I’m having trouble writting the event that checks when it’s 5 days before the date in each column in the same data sheet.

I’d appreciate any help.
@Steve

[Aurelien]

Hi @casitasrd

Your condition will be:

[dueDate]=TODAY()+5

[casitasrd]

@Aurelien I get an error when typing [date column] in the formula field. It’s saying is not of the expected types: yes/no.

I configured everything the same way you have it in your instructions.

Please advise. Thank you so much for your help.

[1minManager]

You’ll need to create a bot

help.appsheet.com

Bots: The Essentials

The triggger will be a Data Change type with this formula

[Date Column]=Today()+5

Simon@1minManager.com

[Aurelien]

(simultaneous answering )

[casitasrd · Accepted solution]

Solution:

Today() = [date column] - 5 = [2nd date column] - 5 = [3rd date column] - 5 …