Power Formulas: Use ChatGPT & AI in Google Sheets

Product details

Q: Hi, can one output populate multiple rows?

We use prompts that generate lists outputs that need to be added to multiple rows.

Enrique.HerbellaJul 7, 2024
Founder Team
Wei_Sheng

Wei_Sheng

Jul 8, 2024

A: Hi yes, you can do this. Once you have tested one prompt and you have multiple rows of context date, you can simply pull down the AI formula to other rows so that the AI returns content based on each row's context. Wei

Share
Helpful?
Log in to join the conversation
Posted: Jul 18, 2024

Hi Wei! That is not what I meant. We use prompts that generate lists outputs that need to be added to multiple rows. This means that the "list" result/output needs to populate each line in multiple rows. For example, if the prompt asks to give me a list of countries that teach English as a second language, then each line (country) of the output needs to be added to a new row. Thanks again!

Founder
Posted: Jul 19, 2024

I see, thanks for the update. We are developing the AI_LIST formula and it will be available soon. Thanks!