Automation involving 2 rows

Options

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!

Tags:

Best Answer

Answers