Copy Row on Last Day not working
I have a sheet with a single row of data:
Primary / Date / Count of <type1> Projects / Sum of <type 1> Project Days / Count of <type2> Projects / Sum of <type 2> Project Days / Total Projects / Average days
Primary column has a 1 in the cell. The rest of the row cells are formulas. Date is =today().
I want to copy that row to a monthly log on the last day of each month using the following automation but it has not copied the past two months. Any suggestions as to why this will not work?