Automation involving 2 rows

Joel Eldredge

I have a sheet with a list of tasks that need to be done.

Example:

row1, checkbox, task name, who, start date, finish date

row2, checkbox, task name, who, start date, finish date

I would like to have the checkbox in row1 to trigger an alert to the who in row 2. Can someone share if this is possible and if so how should I go about doing it?

Thanks in advance!

Leibel S

Create 3 helper columns:

1. Line ID(Should be a system auto-number)
2. Row Number (column formula: =MATCH([Line ID]@row, [Line ID]:[Line ID], 0)
3. Previous Row Checked (column formula: =IF([Row Number]@row <> 1, INDEX(checkbox:checkbox, SUM([Row Number]@row) - 1))

Run your automation on the Previous Row Checked Column.

Leibel S

Create 3 helper columns:

1. Line ID(Should be a system auto-number)
2. Row Number (column formula: =MATCH([Line ID]@row, [Line ID]:[Line ID], 0)
3. Previous Row Checked (column formula: =IF([Row Number]@row <> 1, INDEX(checkbox:checkbox, SUM([Row Number]@row) - 1))

Run your automation on the Previous Row Checked Column.