-1

I am trying to pull scores from one google sheet to another, and I want this information to update when a new form is submitted by the same person.

Score page enter image description here

Summary Page

enter image description here

Link to sheets

Link to Google Form

1
  • The sample spreadsheet gives "Access denied." May 17 at 21:49
1

Try this in cell Summary!B3:

=arrayformula( 
  iferror( 
    vlookup( 
      A3:A, 
      sort('Colors'!B2:N, 'Colors'!A2:A, false), 
      columns('Colors'!B2:N), 
      false 
    ) 
  ) 
)
2
  • It returned a blank cell. Don't I need to reference the sheet called colors?
    – Kim
    May 17 at 21:59
  • 1
    Replace the instances of 'Colors' in the formula with the name of the sheet where the responses are. I cannot see your real sheet names, because the sample spreadsheet continues to give "Access denied." May 17 at 22:09

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.