Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

google sheets - how to - Automatically Move Row down Based On Dropdown

Hi, I am new to Google Sheets, Can someone help me with the code to move the entire row to an other certain row if I change the Column F to 'done'.

ExampleẢnh chụp Màn hình 2024-12-18 lúc 16.56.52.png : if i change F3 to 'done' then entire row 3 will be automatically moved to after row 40
Note : Filter function did not work in this case for us ^^ i tried macro but... had to active macro manually ^^ , it would be great if a script that help to do it automatically, thanks for any help

0 1 589
1 REPLY 1
Top Labels in this Space
Top Solution Authors