Mark comments as "resolved" + access to comments count and status via Formulas

We use Coda to manage our team’s project. There are tables with different project entities. Let say there is Game characters table. We discuss each character in comments to it’s record in table, so we want to:

  1. Determine if there are new comments for every row
  2. Highlight rows with unresolved comments
  3. Mark comments as resolved and hide that yellow triangle without removing them

Would add to that the ability to display the last (n) comments in a column