search

boilermaker-ben / Google-Sheets-NFL-Pick-Ems-and-Survivor-Pool

A single long script to paste into the Google Sheets script editor that generates weekly Google Forms and weekly, overall, and other sheets for running a pick 'ems and/or survivor pool. Hosted by you. Free to use for friends and family.
Apache License 2.0
13 stars 1 forks source link

Week 5 Error #18

Open vruel0529 opened 1 month ago

vruel0529 commented 1 month ago

Hi, for week 5 I'm trying to activate the code 'check NFL scores', but I keep receiving this message :

Exception: The number of rows in the data does not match the number of rows in the range. The data has 14 but the range has 16.

I imported all the responses for the survivor and I also updated the NFL schedule.

vruel0529 commented 1 month ago

I think it has to do with the number of games this week because there are 14 games, but it is like we import 16 games.

boilermaker-ben commented 1 month ago

You are most likely right to assume it's related to the fact that there are only 14 games this week.

Are you doing a survivor-only pool? Has the script worked fine for the past weeks?

For now, you can always manually input the winners via the "NFL_OUTCOMES" sheet yourself (or the WK5 sheet's lower row, if doing pick 'ems).

vruel0529 commented 1 month ago

Yes, I am doing the survivor only pool. So if I manually input the NFL_OUTCOMES everything will be fine? It worked last week.

boilermaker-ben commented 1 month ago

Yes, entering on the NFL_OUTCOMES should work as expected. Have you tried that for week 5? I haven't had anyone else message me about this error, so hopefully somehow its isolated to your pool somehow, but I do need to look into it still.