Is there a way I can combine an updated row notification with a date before and after notification?. By that I mean is for example- If someone updates a row or column, notification can be sent out after the custom date we want?. Thank you
One way I could think of, is to have two separate automations & a date column:
- Automation that detects the update to a cell and sets a date cell in the same row.
- Date arrives automation that sends email on/after/before the date in the date cell.