Matching Plant Images Internally

[merrimacga]

Merrimacga, you can lock any range that people shouldn't edit if you like, that should at least offer some protection.

Maybe. Like the last time when I protected the comments comparison, we may have to run a test but I have to check the available options and do some tests of my own first. I have to be certain any protection added won't restrict participants' ability to input ratings and comments and, when applicable, add new matches. There are several things I know I can do in Excel but not sure I can do them in Google sheets. Stay tuned. I won't make such changes while others are editing. This may take awhile.

I found another error in the workbook tonight and corrected it. Fortunately, this time it was a minor correction and I didn't have to revert to a previous version.

I also played around with the protection in just the ratings sheet and I am ready for one or more participants to test the changes (also added this as a completed change in the wish list tab):

• In columns A-G, P-Q and cells R2:V5, I protected the cells below the header for rows that have entries so only Koen and I can edit them. I can add protection to new row entries in these columns as they are added. I didn't protect the headers themselves because I wasn't sure if that would affect usage of the filter buttons.
  • Test 1: I need participants other than myself and Koen to see if they can edit any of these cells.
    
  • Test 2: I need participants to confirm the filter buttons on these columns still work correctly. Please be sure to clear the filter when done testing.
    
• In columns H-O for all cells below the header for rows that have entries, I added data validation so that there are now dropdowns that specify the selection that can be entered (0,1,2,3). Blanks are accepted but other entries will be rejected and a warning message will display. The data validation should not affect the formulas in columns P-Q and linked cells elsewhere in the workbook should still display correctly.
  • Test 3: I need participants to try using the dropdown button to rate a match in their rating column to make sure the dropdown is working correctly in each cell.
    
  • Test 4: Entries can be typed in manually as well. I need participants to test this by trying to enter both valid and invalid entries to make sure both the data validation and the error message are working correctly.
    

Please add a new post here to let me know the results of the tests if you perform them. Hopefully, this will do the trick and reduce or eliminate the need for reverting to previous versions or other error corrections.