Google sheet list capacity!

i’ve made an app to register names on google and and when reached to the name 147 in the list this’s what i get !!
how can make it at least accept 400 name ?


Read the error. You are having only 6 items in the list but you are trying to take 7th item. , it is impossible

1 Like

it was working fine , but suddenly this happened. .

advice pls

Use if else statement. Actually it is working fine. You have not have equal rows in every list. That’s why it throws the error.

If the length of the list is 6
use condition
Else if length of the list is 7
use condition.

1 Like