Automatic Move Row and External Sheet References

I am having issues with the Automatic move row function and external sheet references.

It doesnt seem that the automation will trigger if the formula needs to look up a value from a different sheet. Proofing is not turn on for this sheet. See screenshot for the formula

Automation: If cell= "a number", then move to another sheet.

Item 1: Date column from the received PO spreadsheet

Item 2: Look up value (PO number in this case) from the local sheet

Item 3: PO column in the Received PO sheet.

I do notice when I open the sheet, it takes a second or so for the lookup of references to be calculated, so maybe the status of the cell is not being stored when the sheet is closed?

SS Formula.jpg

Find more posts tagged with

Manufacturing

Formulas

Cell linking

Comments

Genevieve P.

You are correct: currently the Move Row automation requires the trigger to be based within the source sheet. A cell link, either from a cross-sheet formula or from cell-linking, cannot be the trigger for this type of automation. (Please submit a Product Enhancement Request when you have a moment!)

You may want to create a helper check-box column that could be the trigger for the workflow, instead. Then, set up an easily recognizable conditional formatting rule based on your preferred column (for example, turn the row blue if this column contains a number). The next time you open the sheet you can quickly check all the boxes for the rows that should be moved, then save the sheet to trigger this workflow.

Cheers!

Genevieve

Andrée Starå

Hi Matt,

The third-party service, Zapier could also be an excellent option for this scenario. Is that an option for you?

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…