Start free

Get AI answers you can filter

After this lesson you can turn each answer a Use AI column returns into its own column, then filter and sort on it.

1:13 video with captions, written steps and transcript. Checked against Duckrow on October 3, 2026.

0:00 / 1:13

Narration: preview voiceA private equity team screens HVAC companies against its thesis. The companies are example data.

The short answer

Ask your Use AI prompt for named answers, such as fit_score and fit. Click a finished cell to open Cell details: each answer is a card with Add to column. Name the column and press Add Column. Numbers become a Number column and the rest Text, filled for rows already run and every later run. Then filter, such as Fit score greater or equal to 7.

Step by step

  1. 1Name the answersIn a Flexible Use AI prompt, say what to return, for example: Return fit_score (1 to 10) and fit. The Lead fit template already does.
  2. 2Open Cell detailsClick a cell that says Process Complete. Each answer key is a card.
  3. 3Add to columnPress Add to column on a card, name the column and press Add Column. Numbers become a Number column, everything else Text.
  4. 4FilterFilter, + Add filter, pick the new column: Greater or equal to on numbers, Equal to or Contains on text.
  5. 5Check run statusFilter the Use AI column itself by Has an error, Has results, Has not run and more.

Try it in Duckrow

About five minutes, in your own workspace.

  1. Run a Use AI column with the Lead fit template on 10 rows.
  2. Open a finished cell and add fit_score as a column.
  3. Filter that column to 7 or more.

You're done when your table shows only the rows the AI scored 7 or higher.

Check what stuck

Three quick questions. Nothing is saved.

  1. 1. You add fit_score as a column. What type is it?

  2. 2. You run 500 more rows tomorrow. What happens to the Fit score column?

  3. 3. Some rows never got an answer. How do you find them?

Transcript

0:00Answers you can sort

An AI answer is only useful if you can sort and filter on it. Here's how to give each answer its own column.

0:09Ask for named answers

This team's Use AI column ran the lead fit template, which asks for four named answers: a fit score, a fit of strong, maybe or weak, reasons, and missing information.

0:22Open Cell details

The cells say process complete. Click one, and Cell details shows a card for each answer.

0:29Add each one as a column

On fit score, click add to column. Name it Fit score, and add column. It fills for every row already run, as a number. Do the same for fit.

0:41Filter and sort

Now filter like any column. Fit score, greater or equal to seven, and the screen narrows to the strong fits. You can also filter the AI column itself, for example rows that have an error.

0:56Recap

To recap. Ask the prompt for named answers. Open Cell details and add each one to a column. Then filter and sort them like any other. Next, pick a model and know what it costs.