Inconsistency with copy row automation

Hello!

I am running into some issues when attempting to utilize a copy row automation. Sometimes the rows are copied to another sheet, and sometimes they're not. Here's a breakdown of my process...

Sheet 1- approval workflow is automated upon form submission, records a date when approval is granted

Sheet 2- utilizes a VLOOKUP function to pull the date from sheet 1, also utilizes a helper column to check the recorded approval date to today's date, ***automation is set to copy rows to a third sheet when rows are changed and the helper column is equal to a certain value***

Sheet 3 - should have the rows copied onto it

*** The automation to copy rows from sheet 2 to sheet 3 is where I am having trouble. I've tried to set the automation to read the date itself, but even that doesn't work.

This has been an extremely frustrating issue! Does anyone have some advice or insights from dealing with a similar issue??

Thank you in advance!!

Find more posts tagged with

Forms

Sheets

Formulas

Automations

Accepted answers

Brandon Vanlandingham

Goodmorning @Andrée Starå !

Unfortunately, I think that's going to be the not so easy answer to my issue... I was hoping to avoid the recurrent workflow so that the rows would copy instantaneously, but I may just have to settle for hourly updates.

I remembered this passage, but the intention was for the cross sheet formula to trigger a sheet change in sheet 2, this change in sheet 2 would then trigger the copy row automation. I suppose it is essentially the same process, but just with an extra step.

Thank you for your response!! I hope you have a wonderful weekend as well!

Cheers,

Brandon

All comments

Andrée Starå

Hi @Brandon Vanlandingham

I hope you're well and safe!

Could this be the reason why it's not working?

To prevent infinite approval loops, cells which contain cross-sheet formulas or cell links will not trigger an automation which automatically changes the sheet (Move Row, Copy Row, Lock Row, Unlock Row, Approval Request). To work around this, consider using time-based automation or recurrence workflows.

I hope that helps!

Be safe and have a fantastic weekend!

Best,

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

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

Brandon Vanlandingham

Goodmorning @Andrée Starå !

Thank you for your response!! I hope you have a wonderful weekend as well!

Cheers,

Brandon

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.