I finally managed to make Kindle Collections work and sort books according to series

However, I ran into an issue with a custom column I created to identify books I'm done reading. I used "read" as the lookup name and the column is labeled as "Finished Reading", with the column type set to "comma separated text...".
On the Customize Kindle Collections part, I left everything blank in the row for the "Finished Reading" column but I set the dropdown menu for it to "Create".
I placed the text "read" under that particular column to mark books I've read. However, when I run preview, only the series gets sorted into collections and not the custom "Finished Reading" column.
Can anyone help me? Or is there a better way to have a collection for books I'm done reading? Thank you!