Back again, with the next fixes! I'm ashamed that this escaped from me because it was so clear and I should have noticed it ages ago, even as early as when I designed Home tab. Again, these are fixed in the public files already!
Error was that the fics you have marked with the status reading didn't appear in the Home tab, same with fics you have clicked the checkbox as true. With the checkbox area, the title of the fic disappeared too. But not to worry, these are quick and easy to fix!
Contents
Reading at the moment
1. Choose cell A7.
2. Copy and paste the formula below to the formula line (see the picture below the new formula).
=IFERROR(FILTER(Fics!B4:F, F_ReadingStatus="Reading"), "")
Checkbox
1. Empty column G from row 18 to the last one. (For some reason, the formula is in every cell and it would stop the formula from working.)
2. Choose cell G18 and copy and paste the formula below to the formula line (please, see the picture under the next two steps to see more details).
=IFERROR(FILTER(Fics!B4:D, C_Checkbox=true),"")
3. Choose cell K18:L18 (merged cell) and copy and paste the formula below to the formula line (please, see the picture under the next steps to see more details).
=IFERROR(FILTER(D_Title, C_Checkbox=true),"")
4. Choose cell K18:L18 (merged cell) and copy and paste the formula below to the formula line (please, see the picture below to see more details).
=IFERROR(FILTER(E_Author, C_Checkbox=true),"")
Tips for using checkboxes
It has brought some questions about how to use them. It's for any use you might think you want to use it. I use it for marking the most interesting fics I haven't read yet to make it easier to find something to read after I have read the one I'm reading at that moment. One of the users also tipped that they add more columns to the checkbox area.
Do you want to see the main pairing? You can add it by adding the next formula to for example cell P18:
=IFERROR(FILTER(S_MainPairing, C_Checkbox=true),"")
Do you want to see the summary? You can add it by adding the next formula to row 18, to the column you want to get it (so, for example adding a new column and adding it to cell Q18):
=IFERROR(FILTER(AC_Summary, C_Checkbox=true),"")
Do you want to see your own notes/comments that you can add in Fics tab? You can add it by adding the next formula to row 18, to the column you want to get it (so, for example adding a new column and adding it to cell Q18):
=IFERROR(FILTER(AD_Comments, C_Checkbox=true),"")
Note that you are not supposed to do any notes or markings to the Home tab! They will not move to the Fics sheet and they wouldn't follow that specific fic if you choose to filter/sort the fics some other way.
Also, almost every column in Fics tab has their own named range. You can find all the named ranges from Data > Named ranges, in case you want to edit something. However, do not change the names of the ranges, they appear in multiple places, including scripts and would need to be updated manually.