Can Smartsheet AI identify all rows that are associated to a similar issue?

MikeWhite

Working in a ticketing system. I would like to use AI to look at each ticket problem description and be able to group "like" tickets.

Is there a way for AI to do this? I wasn't able to find an AI command that worked for this.

Brian_Richardson

Short answer no.

Right now AI is just text summaries and helping write formulas, as well as do charting in-sheet.

The text summarization is probably the closest to what you want, but it's "one time only" type of execution, not an ongoing function that refreshes. And it does just text summary, it doesn't manipulate the data or row order.

You could try writing a formula that looks for certain keywords and applies a category, then group on that category in your reports. Or if you have access to Gemini you could sync your data out to Google Sheets, have Gemini review and apply categorization, then use Data Shuttle to pull those results back in for reporting and grouping.

If you want to reorder the sheet or move rows under parents, you'll need to use the API for that through a tool like Bridge. Bridge can also send data to/from ChatGPT and similar AI bots, so you could potentially develop a Bridge workflow to read your sheet, send to ChatGPT, get results back, and then leverage the results and some Javascript to reorder your sheet.

Brian_Richardson

Short answer no.

Right now AI is just text summaries and helping write formulas, as well as do charting in-sheet.

The text summarization is probably the closest to what you want, but it's "one time only" type of execution, not an ongoing function that refreshes. And it does just text summary, it doesn't manipulate the data or row order.

You could try writing a formula that looks for certain keywords and applies a category, then group on that category in your reports. Or if you have access to Gemini you could sync your data out to Google Sheets, have Gemini review and apply categorization, then use Data Shuttle to pull those results back in for reporting and grouping.

If you want to reorder the sheet or move rows under parents, you'll need to use the API for that through a tool like Bridge. Bridge can also send data to/from ChatGPT and similar AI bots, so you could potentially develop a Bridge workflow to read your sheet, send to ChatGPT, get results back, and then leverage the results and some Javascript to reorder your sheet.