Thanks. Got it. Here's how I did it:
1) Create a new custom column called "Collection"
2) Set it to "Column built from other columns"
3) Set the Template field to "{series:|({author}) |}"
4) Set the "Kindle Collections" plugin to create collections using my "Collection" column
Line 3 above is used so that if the book has no "Series", the new "Collection" stays blank, and if the book has a "Series" the "Collection" column is set to "(author name) series".
For example, if I have a book called "Tom Clancy - Dead or Alive" and the series is set to "Jack Ryan", the new "Collection" column will read:
(Tom Clancy) Jack Ryan
|