Move the data

1

Hi i want to know how it possible to move the row of google onthe other google sheet when you change the status of an cellule.thanks

2

Hello, I’m not sure what you mean by “move”. You can copy or reference data in another sheet and cell. Use ‘=’ to reference another cell, and you’ll probably use the IF function should you reference another cell based on a condition.

3

Not copy i want cut and past in other sheet

4

I would not know off the top of my head.

I would Google it and explore two ideas:

  • A series of if conditions. I feel there would be a loop and I don’t know if Google Sheets accepts those.

  • Google App Script, “cloud-based JavaScript platform that lets you integrate with and automate tasks across Google products.”