.png){kind=logo}
What is everyone doing to get around the cell limit size issue? 7000 o...
What is everyone doing to get around the cell limit size issue? 7000 or 8000 characters gets pretty limiting. Such a strange limitation.
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Hey, thanks for reaching out! It's something the team is looking into but the limit is to ensure performance is best since some providers can return too much information and potentially cause issues if the results are expanded across the entire table (hundreds of leads).Some users distribute the data across 2-3 columns in batches of 8k characters, but if you don't need the data in a column and just chatGPT to infer insights from it, I recommend giving it directly into the prompt section. Hope it helps!
Kevin P.··Do you have a tutorial on how to spread the data across columns?
Sorry for the delay, Kevin! Not quite a tutorial but I would just add two or three columns and ask the formula generator to give me the first 8k characters from a column. Then in a second column, I tell it to give me the next batch after the first 8k or just copy the formula an edit the ranges in the code.
I can make a video but that's basically the prompt I give it: "return the first 8000 characters from /column"