Automation involving 2 rows

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!

Find more posts tagged with

Automations

Accepted answers

Leibel S

Create 3 helper columns:

Line ID(Should be a system auto-number)
Row Number (column formula: =MATCH([Line ID]@row, [Line ID]:[Line ID], 0)
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.

All comments

Leibel S

Create 3 helper columns:

Line ID(Should be a system auto-number)
Row Number (column formula: =MATCH([Line ID]@row, [Line ID]:[Line ID], 0)
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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.