Time automation from a text cell

Platform discussions
1

Hi,
Can I make an automation which when I fill a number in a text cell and after the next, let’s say, 7 days it will send a message if the next
cell is still empty?
Something like in the picture:
If the “ERNP AMOUNT” cell filled on July 1st it will start to count and if the “DEPOSIT DATE FOR BOOKING FEE (ACCOUNTING)” cell is still empty after 7 days, it will send an automatic email to whom I will choose, or I need to add a date cell that need to be filled after the “ERNP AMOUNT” cell will be filled?

Sorry for the broken English and I hope that everything is understandable.

Thank you!

image
image703×160 6.04 KB

2

Hi @GalCavaliero. You will need a Date column to make this work (lets call it Check Deposit Date):

  1. When “ERNP Amount” changes AND ONLY IF ERNP Amount is not blank, set “Check Deposit Date” to today AND THEN push “Check Deposit Date” by 7 days

  2. WHEN “Deposit Date for Booking Fee” changes, AND ONLY IF “Deposit Date for Booking Fee” is NOT blank, clear “Check Deposit Date”

  3. WHEN “Check Deposit Date” arrives, AND ONLY IF “Deposit Date for Booking Fee” is blank, Notify…

These would all be custom automations.

Hope this helps,
Mark

3

Thank you!
I’m very appreciate it!