Hi,\u000aI am trying to create an automatization to send an email if there are 3 days to a value date in a column, however I am continuously receiving an error message.\u000a1. Is this possible?\u000a2. can we reference range of cell\u0027s value with a tag?\u000a\u000aI would like to verify if any value in a cell range is met as a condition to trigger an emai.

Hi, you can use the merge tags listed here https://help.logicsheet.co/automation/merge\u002Dtags. you can use merge tags like {{triggering row N value}} and {{range A1}} to refer to dynamic values in Google Sheets. However, it is not possible to send an email 3 days before a date, all automations are concurrent to the trigger event.

Value in Column condition | Logic Sheet - Create AI agents & automation in Google Sheets

ciprian7

Jan 25, 2025

Q: Value in Column condition

Hi,
I am trying to create an automatization to send an email if there are 3 days to a value date in a column, however I am continuously receiving an error message.
1. Is this possible?
2. can we reference range of cell's value with a tag?

I would like to verify if any value in a cell range is met as a condition to trigger an emai.

Helpful?

Logic Sheet - Create AI agents & automation in Google Sheets

Share Logic Sheet - Create AI agents & automation in Google Sheets

Related questions