Changing multiple row on app

Hi All,

So we use smart sheets for controlling where parts are kept. we might have a box of 20 parts that all have their own row which has a barcode on it.

We then put a box number against all the rows. When we move that box i want to be able to change the "location" cells to where the box it. Ie in the workshop or at a contractors.

On the computer i can just filter by the box then change the location cells to the appropriate location.

In the app there is no filter function. Is there an easier way to do this?