20-10-2023, 06:10 AM
I noticed some formatting issues in the ratings workbook tonight when I went into it to work on my ratings and comments. The data in the ratings sheet appeared recently re-sorted and filtered. This also affected the sort of all the individual comments sheets and the ratings sheet ratings key and reference links (columns Q and R). The data itself was unaffected. I fixed this and then added filter buttons to the column headers in (a) the ratings sheet (all except columns Q and R) and (b) each of the individual comments sheets. I also resized the columns so that all the header text is still visible even with the filter buttons displayed. Now participants can use the filter buttons instead of the filter view to limit the data displayed while completing their edits. One really cool thing about this is that you can now filter to only view blanks (i.e. view rows that have cells with no entry)...no re-sorting required. Just be sure to reset the filter when done so that all data is visible again before the next person needs to make edits. A more detailed description of the structural changes can be found in the wish list tab.


![[+]](https://www.voynich.ninja/images/collapse_collapsed.png)