AI Text and Summaries Column Formula

Dakota Haeffner

Hey All,

I submitted this product enhancement request through a feedback request a while back but I think this idea has a lot of merit and would really benefit the community as a whole. If you are like me, I'm sure you are all using and loving the AI feature!

One thing that has been cumbersome about it has been that in order to use the summarization feature you must apply the formula to each row individually. For example, I have a Request Description and a Request Type column that provides the details of the request and I use the AI tool to populate another column titled Request Title. In the column description of Request Title I have, "AI: Generate a generalized version of the [Request Description] and the [Request Type] cell into a short title the explains the Request description as a whole. The title will ideally be 4-8 words." which I paste into the AI feature to provide a title for that row. Usually I let 10 or so request come in so I can do it all at once but it can take a good amount of time.

How cool would it be if you could make a column formula that says something like:

=AITAS([Request Description]@row, "Generate a generalized version of the [Request Description] and the [Request Type] cell into a short title the explains the Request description as a whole. The title will ideally be 4-8 words.", [Request Type]@row)

Allow me to explain in terms we are probably more familiar with.

AITAS = AI Text and Summaries

Example:

=AITAS(Value_to_assess, Prompt_to_AI, [Additional_Value_to_Assess1], [Additional_Value_to_Assess2, …])

Summary:

Returns the AI's Summary after assessing the values at the cell(s)

Arguments:

Value_to_assess: The value, typically a cell or rang of cells, referenced in the Prompt_to_AI.

Prompt_to_AI: A prompt defining the task you are asking the AI to do.

Additional_Value_to_Assess2, … [optional]: Additional values or ranges to refer to in the Prompt_to_AI.

First time write out one of these formula statements so be kind haha!

Let me know what you people think! 😁

Giovanni_64

I can definitely see this formula working for enhance data analysis giving that the formula would allow for quick and consistent summaries. It would allow me for example to easily analyze and interpret large volumes of data which can certainly lead to better insights and decision-making.