I am using Google Sheets and I have two sheets in one document (SHEET1 and SHEET2). I want to be able to use a formula that allows me to:
If cell A1, B1, D1 and F1 in SHEET1 have an
Then cell A1 in SHEET2 automatically inputs an
Can this be done?