Best answer

Looking up more than 10 lines in google sheets

  • 1 September 2021
  • 1 reply
  • 78 views

Hi, 

 

I am trying to figure out a workaround about this issue.

 

I have a table with a column which boolean types of data (TRUE or FALSE).

I would like to lookup for the rows with TRUE value and create rows with their value in another table.

 

Any suggestions on how I could lookup and create more than 10 rows?

 

Thanks in advance.

icon

Best answer by AndrewJDavison_Luhhu 1 September 2021, 12:10

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +10

Hi @Ikgonzal 

You can’t do a lookup of more than 10 rows directly, but there is a long-winded workaround to loop all rows:

https://www.luhhu.com/blog/video-creating-a-looping-zapier-automation-using-webhooks