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! 😁
Comments
-
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.
-
It would be very helpful and a time saver if the AI generated text and summaries button could be implemented like the formulas and able to be automatic in a cell instead of a button. For example, instead of me having to go in and generate the AI, I could reference the cells that I want it to create the summary for me in the cell automatically. It would be a dynamic cell like the formulas where as the parent cells are added and as you tell it what to include in your cell, the AI changes accordingly.
-
Any movement on this? I could also see this being useful to summarize what's happening on an entire row for purposes of executive summaries. I work in municipal government and we have a sheet that tracks "problem properties" (e.g. abandoned homes used for illegal activity, properties with constant blight violations, etc.) and has multiple different departments (police, buildings safety & environmental, public works, etc.) working on each property to tackle it in a coordinated manner.
It would be nice to use this column formula to have a dynamic summary of what's going on with each property that could be used for weekly updates to the mayor. Even better than that, we could then use data shuttle to create a running tally of the summaries week to week to see how things are changing over time and what progress is being made.
-
I like this idea. It seems like it could also be handled via the suggested AI column formula idea in this thread:
https://community.smartsheet.com/discussion/133449/ai-text-and-summaries-column-formula?utm_source=community-search&utm_medium=organic-search&utm_term=AI+text+summary
