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?
提前谢谢!
Best Answer
-
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.
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.
Categories
You would use the below for Jan 2023 and adjust the month and year numbers accordingly for each of the other months.<\/p>
=IF(AND(MONTH([Start Date]@row)<= 1, YEAR([Start Date]@row)<= 2023, MONTH([End Date]@row)>= 1, YEAR([End Date]@row)>= 2023), [$ per month]@row)<\/p>"},{"commentID":387901,"body":"
Lets try a different approach.<\/p>
=IF(AND(VALUE(YEAR([Start Date]@row) + IF(MONTH(Start Date]@row)< 10, \"0\", \"//www.santa-greenland.com/community/discussion/72827/\") + MONTH([Start Date]@row))<= 202307<\/strong>, VALUE(YEAR([End Date]@row) + IF(MONTH([End Date]@row)< 10, \"0\", \"//www.santa-greenland.com/community/discussion/72827/\") + MONTH([End Date]@row))>= 202307<\/strong>), [$ per month]@row)<\/p> Basically we are creating a yyyymm stamp from the start and end dates and comparing them to the yyyymm stamp for that year\/month combo. The above is for July 2023 (202307).<\/p>"},{"commentID":387906,"body":"
<\/p>
![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/G1SDKXPQ7I1D\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/GCQ7U05Q4GNO\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/79GD9D2EWXCW\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
