on edit copy values to another sheet dynamically google sheets
=IMPORTRANGE("https://docs.google.com/spreadsheets/d/123123123123/edit#gid=1816927174"&"?"&now(),"'Sheet1'!A1:B25")on edit copy values to another sheet dynamically google sheets
=IMPORTRANGE("https://docs.google.com/spreadsheets/d/123123123123/edit#gid=1816927174"&"?"&now(),"'Sheet1'!A1:B25")google spreadsheet copy values from another sheet conditional
I see in the sample, sheet Form Responses, column C is Status. However, none of them are marked "Finished". If the rows were marked, the FILTER function could be use to display a list in the sheet Completed. Something like this
=FILTER('Form Responses 1'!A:Q, 'Form Responses 1'!C:C="Finished")
If you mark some of the rows "Finished", the results will display in the Completed sheet.Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
