Copy Row on Last Day not working

Matthew Barrett

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?

-Matthew

Brett Wyrick

Hey Matthew.

Can you change the "Condition" to "Primary Column" to "is not blank"? That'd still meet your requirement for this sheet, right?

I'm just spitballin' here, but I'm thinking that the "Primary Column" is getting read as a string instead of an integer, which is not triggering the automation. Just a guess. Can you give that a test run? (You can change the "Trigger" to "When a date is reached" then select Today at whatever time you'd like).

Brett Wyrick

Hey Matthew.

Can you change the "Condition" to "Primary Column" to "is not blank"? That'd still meet your requirement for this sheet, right?

I'm just spitballin' here, but I'm thinking that the "Primary Column" is getting read as a string instead of an integer, which is not triggering the automation. Just a guess. Can you give that a test run? (You can change the "Trigger" to "When a date is reached" then select Today at whatever time you'd like).

Andrée Starå

Hi @Matthew Barrett

I hope you're well and safe!

Strange!

• Have you looked for clues in the Activity Log?
• Have you looked in the other sheet at the bottom?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Matthew Barrett

I ran a few tests based on the suggestions received. Changing the condition to "Primary Column" not blank worked.

Andrée Starå

@Matthew Barrett

Excellent!

Glad you got it working!