Not sure this is the right place to ask for help. I'm not great with technology, I love this program and have been able to figure out a few things, but I get stuck sometimes and I don't know the lingo or have the brains to dig myself out
So please bear with me.
I have created a custom column I called "Read by" since my calibre has both my books and my daughters. I wanted to be able to "see" books that I have read versus hers or ones we both read. When creating the column I used the type as "text column for Keeping series like information". I did this because I didn't really know what I was doing and it seemed to do exactly what I needed. The plus side is that once I add text (i.e. my name) it also added a numeric number. Which I thought was great, now I can sort by my name, daughter's name or the word both and it will also show me how many books for each.
The problem: I have since noticed I somehow "marked" books with my name that I did not yet read. I just deselect my name and left it blank, BUT the numbering is now off. I don't know how to fix this, Example it starts when I sort with my name Lisa I get all the books marked with my name but it starts at [9] (I obviously deselected 1-8).Is there a way to fix this or do I have to delete the column and start over manually? (having palpitations thinking about having to do that )
Thank you for your help and I apologize if I stuck this in the wrong area!