Best Of

Hi @MYaussi

I think your copy rows automation is a good idea and will work, but here is a different approach.

Helper Numbers Column Approach

The demo solution below multiplies a single row into multiple rows in another sheet, using a helper column, [#], that starts from 1, and increments by 1, like 1,2,3,...,100.

https://app.smartsheet.com/b/publish?EQBCT=b393f88f3cd3438198c6f0c894d77237

In this demo example, since we have up to 4 tasks for each giveaway project, we get the corresponding Row ID by the following formula.

[Row ID] =INT(([#]@row  + 3) / 4)

Using the Row ID, we can get the Giveaway ID, Project Name, Start, and End by the following formula, using VLOOKUP or INDEX MATCH.

[Giveaway ID] =IFERROR(VLOOKUP([Row ID]@row , {Giveaway : RowID to Web Banner Pubs}, 2), "")


[Project Name] =IFERROR(VLOOKUP([Row ID]@row , {Giveaway : RowID to Web Banner Pubs}, 3), "")

[Start] =IFERROR(VLOOKUP([Row ID]@row , {Giveaway : RowID to Web Banner Pubs}, 4), "")

[End] =IFERROR(VLOOKUP([Row ID]@row , {Giveaway : RowID to Web Banner Pubs}, 5), "")

As for the [Crtv Apprv], etc, we show them only in the corresponding row using the following formula.

[Crtv Apprv] =
  IF(MOD([#]@row , 4) = 1, 
    IFERROR(VLOOKUP([Row ID]@row , {Giveaway : RowID to Web Banner Pubs}, 6), ""))


[Media Upload] =
  IF(MOD([#]@row , 4) = 2, 
    IFERROR(VLOOKUP([Row ID]@row , {Giveaway : RowID to Web Banner Pubs}, 7), ""))


[Omeda Form] =
  IF(MOD([#]@row , 4) = 3, 
    IFERROR(VLOOKUP([Row ID]@row , {Giveaway : RowID to Web Banner Pubs}, 8), ""))


[Web Banner PUBs] =
  IF(MOD([#]@row , 4) = 0, 
    IFERROR(VLOOKUP([Row ID]@row , {Giveaway : RowID to Web Banner Pubs}, 9), ""))

Lastly, I have the [Format] checkbox column, hidden, for formatting purposes with the following formula;

[Format] =MOD([Row ID]@row , 2)

Sample Giveaway Sheet

https://app.smartsheet.com/b/publish?EQBCT=6d32e089d49f4e08b216654ef8670314

To show only rows with a task, you can use a filter.

Copy Rows Automation Approach

Regarding your idea of using copy rows, to just duplicate rows, you can create automations like these;

• When a new row is added
  • Copy to Sheet 1
  • Copy to Sheet 2
  • Copy to Sheet 3
  • Copy to Sheet 4
• At each Copy to Sheet #, when a new row is added
  • Move to Sheet ALL

Copy rows automation at the Giveaway sheet

Move Rows automation at each sheet

Then, you will get, at the destination, ALL sheet, something like this;

The difficulty with this approach is that we get the identical rows. So, for the alert automation, these multiple rows will not help.

To avoid this, you can add a helper column, like [Task #], with a column formula like this.

Note, you need to change the Task # formula for each sheet.

• Copy to Sheet 1: =1
• Copy to Sheet 2: =2
• Copy to Sheet 3: =3
• Copy to Sheet 4: =4

With that, the destination, All sheet, will get Task # like the image below.

Then, you can use the Task # to determine which row should alert which task or checkbox. For example, in the first row above, as Task # is two and the second checkbox is checked, we send an alert based on this row regarding Media Upload.