Move the data

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

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.

Not copy i want cut and past in other sheet

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.”