So I have a Google Sheet I've made at work to simplify our needs for receiving product, the old sheet was a template and people handwrote everything which leads to confusion for people putting the product away.

I am now trying to setup a log for this sheet, in case the original paper goes flying off of a forklift or gets otherwise lost.

This is used by multiple people so I need the log sheet to know when the receiving sheet is completed and move to a new row before they erase the sheet and start over.

Currently it is just importing data from the cells of the receiving sheet and I don't know how to put in a nested formula saying IF this cell, this cell, and this cell are filled in, move to a new row and import the receiving sheet cells here now.

  • Welcome. Please add a brief description of your search/research efforts as is suggested in How to Ask. – Rubén Jan 14 at 17:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.