AI Tools - Generate Formulas - Enhancement

mcullen

I love using the Generate Formulas tool but have a suggestion. In addition to the "Apply to selected cell" option, it would be awesome to also have the ability to apply the output explanation to the column description.

Example.PNG

Jacob A

Hi @mcullen

It seems you are having fun with this already.

@Genevieve P. sorry to be tagging you here but I have a question and not sure how to catch your attention.🙈🙈. My question is, can the "generate formulas" tool reference other sheets? I tried writing a couple of things I want to do in my own words but it always seems to generate the formula base on the sheet, even after I type out the sheet and column name I want to reference.

for example, "Referencing the xxx sheet and ccc column, write a formula to count [bbb] in the ccc column of xxx sheet"

mcullen

Hi @Jacob A

Unfortunately, the Generate Formulas only supports referencing cell values in the current sheet. You can't reference values in other sheets.

Here's a link to a resource guide that I thought was really helpful:

Use AI to generate formulas or text

If you scroll to the bottom, there isa "Know Limitations" section.

Hope this helps!

Jacob A

Hi @mcullen

Oh seen, thanks for letting me know. I kinda figure, when I noticed that it kept generating formulas with the sheet. It was however helpful a bit though as it gave me another view of how to structure the formula.

I would read up on the resource.

Many thanks for sharing and have a restful weekend.

Jacob Alabi

Genevieve P.

Thanks for stepping in, @mcullen! 🙂