Moving Rows

Wanda Jackson

If your sheet is linked to another sheet and you set up a workflow to move rows to a different sheet when a certain criteria is met, will the moved rows remain linked to the other sheet?

Thanks,

Wanda J.

Andrée Starå

Hi @Wanda Jackson

No, they won’t, but if you use column formulas in the destination sheet, it could still work.

Make sense?

Would that work/help?

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 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!

Andrée Starå

@Wanda Jackson

Happy to help!

You'd either use VLOOKUP or a combination of INDEX/MATCH.

Make sense?

Andrée Starå

Hi @Wanda Jackson

No, they won’t, but if you use column formulas in the destination sheet, it could still work.

Make sense?

Would that work/help?

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 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!

Wanda Jackson

Thanks for the response Andree. What formula would I use for this type of transaction?

Andrée Starå

@Wanda Jackson

Happy to help!

You'd either use VLOOKUP or a combination of INDEX/MATCH.

Make sense?

Wanda Jackson

Yes it does. Thanks again Andree.

Andrée Starå

@Wanda Jackson

Excellent!

You're more than welcome!